November 7, 2007 at 7:15 am
I am trying to import an excel file to SQL Server using SSIS. I have developed the process using BI and the process runs correctly when debugging it. However, when I import the package to SQL Server SSIS, the process fails with an error indicating "DTS_E_PRODUCTLEVELTOLOW".
Other SSIS packages (not importing from excel) run correctly using either SQL Server SSIS (execute package) or using BI for debugging.
Any help would be appreciated.
November 7, 2007 at 1:37 pm
is the SSIS service installed and running on the server that is trying to execute the package?
November 7, 2007 at 6:17 pm
Yes. There are other SSIS packages that run independently and as part of scheduled jobs. However, this is the only (first) one that attempts to import a worksheet from an excel spreadsheet. SQL server has had Service Pack 2 installed, however due to some other "curious" issues I have wondered if SP 2 was installed correctly.
Thanks
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply