Agent 2012 unable to run SSDT project

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)

Agent 2012 unable to run SSDT project

Author

Topic

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 09:50:59

Hello

I have created a project in SSDT and deployed to SQL Server 2012.

next I have created a agent job but it will not execute the packages.

can someone tell me when the checklist is when running a package via agent 2012 on SSDT ssis.
On each package I have an email task that fires when a package fails. when I try to run the agent job the failure email works, but non of the other tasks work. so the package is running somewhere, but only one task.

Regards

Rob

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 10:28:49

hmm..whats was the failure reason? any error it gave? see All executions standard report in SSMS

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 10:44:34

in the ssms reports on the first task in the package, which is a script task

Current Day File: Error: Exception has been thrown by the target of an invocation

The script task Current Day File: fetches a file via ftp and saves in local folder

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 10:56:03

then you need to debug script task and see where error is.
Alternatively you could use a FTP Task if its just for doing FTP.
or this if using secure FTP

http://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 10:57:52

but it works when I execute in ssis,

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 11:49:10

I am downloading my files via a secure FTP so the ssis ftp task wont work.

my packages work when I execute them in ssis

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 12:02:04

quote:
Originally posted by masterdineen

I am downloading my files via a secure FTP so the ssis ftp task wont work.

my packages work when I execute them in ssis

are you hardcoding credentials for ftp server inside? also what account is used for running packages from sql agent?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 12:03:32

quote:
Originally posted by masterdineen

I am downloading my files via a secure FTP so the ssis ftp task wont work.

my packages work when I execute them in ssis

which exe are you using? did you check link i posted?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 12:35:35

im using WINSCP

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 12:49:19

quote:
Originally posted by masterdineen

im using WINSCP

then the link i posted has an example you can try

http://visakhm.blogspot.in/2012/12/implementing-dynamic-secure-ftp-process.html

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

masterdineen
Aged Yak Warrior

550 Posts

Posted - 2013-06-27 : 13:02:58

will that work for a sftp with a SshHostKeyFingerprint key

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-06-27 : 13:32:48

quote:
Originally posted by masterdineen

will that work for a sftp with a SshHostKeyFingerprint key

it can

you just need to modify the script accordingly

see

http://winscp.net/eng/docs/guide_ssis#script_file

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/
https://www.facebook.com/VmBlogs

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources