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 2012 Forums
 SSIS and Import/Export (2012)
 IS job not running when deployed

Author  Topic 

Blessed1978
Yak Posting Veteran

97 Posts

Posted - 2014-09-24 : 09:59:43
Why is it that i can manually run my SSIS ftp task job from ssis 2012 and it runs , however when i deploy to SQL SERVER 2012 and create a job it errors out.

i set variables in my IS package for the ftp site's location and my Destination.I think for some reasons the variables i defined are not being identified when i run it as a job.Do i need to define the variables again when i depoy to MANAGEMENT STUDIO.

confused

Bustaz Kool
Master Smack Fu Yak Hacker

1834 Posts

Posted - 2014-09-24 : 11:49:45
When you run it as a job, what security context is it using? Does that security context have access to the FTP site? What error are you actually getting?



Too often we enjoy the comfort of opinion without the discomfort of thought. - John F. Kennedy
Go to Top of Page
   

- Advertisement -