question

vijayvictory avatar image
vijayvictory asked

SSIS 2008 Issue

Hi , I had an old package developed in Sql server 2005(Developed by others).I opened that package in Sql server 2008 bids and fixed some issue.My machine is 64 bit.I generated a manifest file and deployed to dev server using that package.But when I try to deploy the same package to UAT server from a 32 bit machine using the same manifest file I am getting an issue.Issue is Microsoft.sqlserver.dtsruntimewrap.Please let me know why there is a issue.
sql-server-2008sql-server-2005ssis
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Please help us out. The site runs on votes. For all helpful answers please indicate this by clicking on the thumbs up symbol next to those answers. If any one answer lead to a solution you can indicate this by clicking on the thumbs up next to that answer.
0 Likes 0 ·
sqlaj 1 avatar image
sqlaj 1 answered
Is that the full error message? Please provide as much as you can. Other things to consider/look into. Are all SQL Server versions the same? Or is one on the UAT server different? You mention 64bit and 32. Is just your machine 64bit? What is Dev server you said you successfully deployed too? 64? 32? You should look at this post about **64 bit Considerations for Integration Services** http://technet.microsoft.com/en-us/library/ms141766(v=sql.105).aspx Here is another post about **Running 32-bit SSIS in a 64-bit Environment** http://sqlblog.com/blogs/john_paul_cook/archive/2010/03/24/running-32-bit-ssis-in-a-64-bit-environment.aspx
1 comment
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vijayvictory avatar image vijayvictory commented ·
All the dev and UAt servers are 64 bit.My error is Exception from HRESULT 0xC001403C.Please let me know how to fix this issue. Thanks
0 Likes 0 ·
sqlaj 1 avatar image
sqlaj 1 answered
Take a look at this page. Search the page for the error number you listed above. 0xC001403C http://technet.microsoft.com/en-us/library/ms345164(v=sql.105).aspx DTS_E_GETPACKAGEINFOS: An OLE DB error __ (__) occurred while enumerating packages. A SQL statement was issued and failed. It appears the query is failing - At least by the error message. Are all the databases identical? Perhaps the objects referenced in the code have been altered?
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

vijayvictory avatar image
vijayvictory answered
Sorry for late reply.There was some issue with my machine.It got fixed when I deployed from other machine
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.