Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Transact-SQL (2008)
 SSIS JOBS ERROR IN SSMS 2008

Author  Topic 

kond.mohan
Posting Yak Master

213 Posts

Posted - 2012-01-03 : 00:35:22


Hi,

i am running the job on daily basis

when i executed the job i got this error

i got this error

Started: 3:47:36 PM Error: 2012-01-01 15:54:31.39 Code: 0xC0202009 Source: CNTRLR229 OLE DB Destination [16] Description: 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: "Communication link failure". An OLE DB record is available. Source: "Microsoft SQL Server Native Client 10.0" Hresult: 0x80004005 Description: "TCP Provider: An established connection was aborted by the software in your host machine. ".

can anybody knows pls help me

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2012-01-03 : 06:31:22
did you try running package in BIDS? did you get same error? also is your source db same machine in which integration services is running?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -