May 8, 2014 at 9:04 am
i have strange sssis package runs in sql server 2005 calling via sql agent file system, package use connection string to connect for sql server 2008 where data need to load from file. string is used Provider=SQLOLEDB.1;Integrated Security=SSPI; it has been failing intermittently. Anyone has similar issue and fixes for this issue? when i run from bids in sql server 2005 box it runs fine. sql error: DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. Hresult: 0x80004005 SQL Server does not exist or access denied."
May 9, 2014 at 6:22 am
So the job running from the sql agent doesn't fail every time?
May 9, 2014 at 7:35 am
Thats true. It fails 30% of total time of it total execute. i also found out server A and server B has two different port server A 2005 (xxx port) server B 2008 (yyy port) job runs on server A. Does that cause this kind of issue? any idea. never saw these kind of issue before.
May 9, 2014 at 7:51 am
Does it only work when you manually run the agent job, and fail when the agent job runs automatically?
May 9, 2014 at 7:58 am
no manual execution on job..it fails on scheduled job and some time it success.
May 9, 2014 at 9:23 am
Does it run at the same time every night, does it fail certain days and not others? Any extra load on the servers when the job fails?
May 9, 2014 at 9:29 am
Does either server use the default SQL port, if so which one? server A or Server B
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply