November 16, 2011 at 4:12 am
Hi All,
I want to import around 100+ excel files into SQl Server 2008R2, is there a simple way of doing this? or any way of doing?
Thanks
November 16, 2011 at 4:14 am
Same Structure?
November 16, 2011 at 4:20 am
at the moment, through import data tool i can only import a file one by one but i would like to do all at once so i dont to do it 300 times
November 16, 2011 at 4:30 am
If you know little bit of SSIS?
Yes:
1) Create one SSIS Package with Export Import Wizard.
2) Modify it to loop through 300+ files.
2) Execute Package & you are Done. 🙂
No:
Do the same with BULK INSERT or BCP with T-SQL. 🙁
November 16, 2011 at 4:37 am
ok, i do know a lil SSIS but what flow items do i use?
November 16, 2011 at 4:46 am
Do it step by step...
First create a package with Export Import Wizard. It means, Open the wizard, Select source, destination etc. and save it as SSIS Package.
Once done, open this package with BIDS. You will find a data flow inside. You just need to tweak it a bit to suit your requirements.
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply