Depending on the file you can however use a C# script to parse the file and create the table yourself. With bulk insert (T-SQL) it is possible to create the table on the fly though.
frederico_fonseca - Tuesday, November 6, 2018 5:39 PM
not with standard SSIS methods
Depending on the file you can however use a C# script to parse the file and create the table yourself. With bulk insert (T-SQL) it is possible to create the table on the fly though.
So an ExecuteSQL task with a bulk insert might do it.
If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply