none
importing SSIS package with Header and footer

    Question

  • Hello,
    I have a text file with header, detail and footer rows  . I want to import only detail rows to sql server table.

    Sample file 
    data
    NYC|Ny|Usa|Earth
    1

    1st row has file name and last row has total records and in between all are data rows

    For that I did the following.

    1) In Flat file source I selected format as 'Ragged Right' and sending that out put to a script task .
    2)In script task I renamed input column as Data which has value of NYC|Ny|Usa|Earth
    3)In script task under output column I added output columns City,State,Country,universe

    Now I want to connect this script task to Oledb destination and insert all the values in a table with 4 separate columns.

    I am not from .Net background . Can some one help how to write a vb or c# script in script task 

    Thanks
    Monday, April 21, 2014 4:43 AM

All replies