Viewing 3 posts - 16 through 18 (of 18 total)
You can use SSIS to perform these type of Excel File imports to SQL Server.
1) Simply create a new SSIS project in BIDS 2005 or 2008
2) Drag an Excel source...
February 16, 2011 at 6:06 am
#1287595
Thank you for the input ZZartin. I will look at that Task.
February 15, 2011 at 9:04 am
#1287127
Mr. Strate in his 31 days of SSIS has a real life package that performs the functionality that you are rquesting. Here is alink to the aricle that contains a...
February 8, 2011 at 6:44 am
#1283640