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.
| Author |
Topic |
|
kond.mohan
Posting Yak Master
213 Posts |
 Posted - 2012-06-01 : 07:58:21
|
| WE HAVE CREATE SSIS PACKAGE IN (SSMS2008 R2)EVERY JOB IS RUNNING THROUG SQL SERVER AGENT WE HAVE CREATED SQL SERVER LOG FOR THIS PACKAGE BUT AFTER FINSISHED THE JOB WE ARE GETTING THE ERROR Source: Package Log provider "SSIS log provider for SQL Server" Description: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. Source: "Microsoft OLE DB Provider for SQL Server" Hresult: 0x80004005 Description: "Connection failure". End Error Error: 2012-06-01 15:14:24.25 Code: 0xC0202009 Source: Package Log provider "SSIS log provider for SQL Server" CAN ANYBODY KNOWS PLS HELP ME |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-06-01 : 12:13:36
|
| it seems like package is not able to connect to sql server which you've configured to log the execution details of package. Check the oledb connection manager you set for logging and see if you can access the server and db specified in it directly from sql server management studio.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
SSIS PACKAGE (LOG PROVIDER ISSUE)