August 27, 2009 at 6:19 am
Hi everyone!!!
I need help, how can i read an excel file from the source, drop and create a table into sql server based on the name of an excel file that i am importing, note that each and every time when i import excel file, i should be able to check excel file name, create a table with that name into the database, and then from there , i can import my data.....
Thanks
August 27, 2009 at 9:05 am
cecil198248 (8/27/2009)
Hi everyone!!!I need help, how can i read an excel file from the source, drop and create a table into sql server based on the name of an excel file that i am importing, note that each and every time when i import excel file, i should be able to check excel file name, create a table with that name into the database, and then from there , i can import my data.....
Thanks
The first thing you have to do is store the file name in a variable. You can then use the value of that variable to generate dynamic SQL for dropping/creating a SQL table with that file name. You will also need to use that file name to modify the connection string of your connection managers to point to the correct source and destination.
I hope this will help to get you started.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
Viewing 2 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply