Saturday July 22nd 2017

Categories

Insider

Archives

SQL Server Integration Services Excel data import issue.

msoft
I spent quite a time resolving the issue of Data Import from Excel Using SSIS and couldn’t find source which can help me to resolve issue. I was watching the SSIS Project Beginner Tutorial 2 By JRS on youtunbe and it showed how to resolve the issue. Basicaly we have to go Solution Explorer and right click on the Integration Services Project and then go to properties. In the properties we have to got configuration and then in The debugging section. Where if set 64 bit to false then issue is resolved. Watch the Video I have included in this tutorial.


Thanks,
Kaleem Mian