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.
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:
Now I need to call the variable using connection string to get the latest csv file. how can I call that variable?
answered Aug 16, 2012 at 03:17 PM