November 5, 2014 at 2:51 am
Hi,
I am trying to import 8 lac data from excel to SQL server using SSIS package, but it is not able to import the data and system gets stuck.
can anyone help me out.
November 5, 2014 at 3:22 am
Is there an error?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 3:32 am
No there is no threat error.....system just stop working...and Data flow task indicates in Red.
November 5, 2014 at 3:35 am
devananddhudat31 (11/5/2014)
No there is no threat error.....system just stop working...and Data flow task indicates in Red.
Red means that there is an error (or at least should be).
Check the output window and please post anything you find there here.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 5, 2014 at 6:22 am
With Excel and SSIS it could be a whole host of reasons
Just some of the ones I have come across in the past
Excel 64 bit installed on a 64 bit machine (either client or server) - BIDS/SSDT is a 32 bit application
Excel spreadsheet (2007 onwards) is an XML document but if there is part of the workbook that is protected then the XML is encrypted and SSIS can't read it.
Expecting .xlsx extension and getting .xls or xlsm because someone has saved it as 95/2003 format or added a macro
Is there another way to get the source of the data apart from Excel. I would even prefer to export the data from Excel to CSV rather than rely on the Excel file natively
November 5, 2014 at 6:32 am
aaron.reese (11/5/2014)
Excel 64 bit installed on a 64 bit machine (either client or server) - BIDS/SSDT is a 32 bit application
The installation of Office (be it 32-bit or 64-bit) has actually almost no impact on how SSIS deals with Excel.
The only dependency is that the ACE OLE DB provider is installed along with Office. So if you install 64-bit office, you might not have the 32-bit ACE OLE DB provider installed, which is indeed a pain as BIDS is 32-bit.
On a server however, Office will probably not be installed and only the type of ACE OLE DB provider is of importance.
It is possible to install both versions of the provider though: Force installation of 64-bit ACE OLE DB provider[/url]. If you do, you don't have to set the Run64bitruntime property to false in BIDS.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 6 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply