importing SSIS package with Header and footer


  • 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 

    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 

    Monday, April 21, 2014 4:43 AM

All replies