I am trying to create a package to load latest csv file into the sql server and every time it should create a new table based on csv file.
1) First past of recognizing latest csv file is done, using script task. (thanks you guys for awesome post)
2) To create a table based on the latest csv. I have no clue on this one. Currently, I am using data flow task.
a)Flat File Source- using variable base on script task the file name is recognized from the source folder.
b) OLE DB Destination - how can i create table dynamically?
Also datatype for fields should be nvarchar(max)
Hey thanks for the suggestion. I applied a different approach to that.
1) I used a script task to identify the latest csv file and put that file name into a variable based on code provided on the following link:
2) I used a second script task to to create a table for every csv file based on code provided on the following link:
answered Aug 16 '12 at 03:17 PM