question

Selvam786 avatar image
Selvam786 asked

Invalid Objet Name SSIS, Error code: 0x80004005

Hi, Using a SSIS package we are connecting to a server which has two databases. The package dynamically fetches the data from both the databases.when we execute the packages from production server , out of two data base one is throwing the below error. But the same package is loading fine when we execute from development server. Error 2 Validation error. Data Loading Source->Target: Data Loading Source->Target: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "Invalid object name 'V_City'.". Pkg_City_Mst.dtsx 0 0 Please help us to find a solution. Thanks in advance Thanks & Regards, Selvam
ssis
10 |1200

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

1 Answer

·
manoj 2 avatar image
manoj 2 answered
Check V_City database object is exists in the server database where you are executing package and getting error.
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.