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 |
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
 Posted - 2012-04-30 : 11:10:40
|
| Hi,My ssis package has FTP task which connects to FTP site with login details.This ssis package is now triggered by a sql job.When the job runs at specified scheduled time, it says login timeout which refers to logging into the FTP site.But if I manually run the job, it logs on to the FTP site ok.As an additional work, I have added the timeout in the config file for the ssis package to 180 seconds.Do you know what could be causing this issue please?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-30 : 11:22:43
|
| when ssis runs from job which account its using? does the login details have been correctly configured to connect to FTP site from package in job? is it set as a configurable item? in such case, is it getting correct value when executed from the job?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-05-01 : 04:32:34
|
| It works fine using the config file and the login details.I do not see why it times out to log onto the FTP site when it starts running on the scheduled time or any scheduled time.But if the job is run manually i.e. when I start it manually, it connects to the FTP site ok.Could this be solved by apply sp1?Because prod does not have sp1 and this is the server with the problem whereas Dev as sp1 and it works fine.Thanks |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-01 : 10:13:01
|
quote:
Originally posted by arkiboys
It works fine using the config file and the login details.I do not see why it times out to log onto the FTP site when it starts running on the scheduled time or any scheduled time.But if the job is run manually i.e. when I start it manually, it connects to the FTP site ok.Could this be solved by apply sp1?Because prod does not have sp1 and this is the server with the problem whereas Dev as sp1 and it works fine.Thanks
did you try running package manually in prod system? is prod system in same domain as your dev server? can you test ftp connectivity first from prod?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
arkiboys
Master Smack Fu Yak Hacker
1433 Posts |
Posted - 2012-05-01 : 10:19:33
|
| Can not run ssis manually on prod as business intelligent management studio is NOT installed on prod. It is only in Dev.There are other ssis packages running in prod which logonto other FTP sites and work fine.yes, the dev and prod are on the same domain. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-01 : 10:42:06
|
quote:
Originally posted by arkiboys
Can not run ssis manually on prod as business intelligent management studio is NOT installed on prod. It is only in Dev.There are other ssis packages running in prod which logonto other FTP sites and work fine.yes, the dev and prod are on the same domain.
can you try creating a copy of one of package that is currently working and replace ftp connection values with your current ftp values and check?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
sql job timeout