Post reply

Programmatically creating SSIS Package

  • September 28, 2007 at 12:36 pm

    #121720

    I have a plat file source and an OLEDB destination table. I want to write a custom application to get flat text files and use the BULK INSERT function to import the large text files into SQL server 2005. I need help in mapping the source columns to the destination table columns. The source flat file does not have a header row with column names.

    Anybody??? Thanks.

  • October 4, 2007 at 2:56 pm

    #739347

    You can just import ur flat file using import/export ssis wizard and then it will show u an option while ur using the wizard. when u reach to a point where you have your table shown on right side of the tab drop down, u can click on the ellipse .... to map file to table.

    Before doing that it will also ask you whether first row has column name on header or not.

Viewing 2 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply