June 9, 2014 at 8:04 am
I have an SSIS package that is running an FTP task that is connecting to an Informix database. When SQL server executes the package, it fails with the following error: An error occurred in the requested FTP operation. Detailed error description: The operation timed out. I am able to run the package in BIDS. Since the FTP task is connecting to an Informix database, I have to run the job and package in BIDS in 32 bit mode.
I have tried deleting and recreating the job with no success.
I am at a loss as to why the package will run in BIDS but not in the SQL agent.
June 9, 2014 at 8:10 am
Probably because in BIDS, it runs in your security context, whereas in the job, it runs in the context of the SQL Server Agent service account. Have you checked that the latter has access to any resources that you need to connect to during the package execution?
John
June 9, 2014 at 8:52 am
When I run the package in BIDS, I am running it under the same proxy account as the job in order to make sure things are as identical as possible.
June 9, 2014 at 8:55 am
Could it be a firewall or routing thing? Presumably when you run it from BIDS, you're doing it from your PC, whereas with SQL Server Agent, it runs from the server. Perhaps you don't have the network libraries for Informix installed on one of them?
John
June 9, 2014 at 9:11 am
John Mitchell-245523 (6/9/2014)
Could it be a firewall or routing thing? Presumably when you run it from BIDS, you're doing it from your PC, whereas with SQL Server Agent, it runs from the server. Perhaps you don't have the network libraries for Informix installed on one of them?John
I actually run the package in BIDS on the server not my PC
June 11, 2014 at 8:27 am
ended up deleted the connection manager for the FTP and copied it from another package and that seemed to do the trick
thanks for all the suggestions
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply