Home Forums SQL Server 2005 SQL Server 2005 Integration Services Strange issue while loading data from Excel using SSIS package RE: Strange issue while loading data from Excel using SSIS package
Shivanand Kamath
SSC-Addicted
Points: 450
More actions
April 5, 2010 at 12:16 pm
#1145931
Sumon,
I build a SSIS package using the your attached spreadsheet and using Excel Source and Ole DB source. I was able to reload the data with success.
I am attaching the screenshot from the SQL query output of the loaded data.