SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2012 Forums
 SSIS and Import/Export (2012)
 Agent 2012 unable to run SSDT project
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  09:50:59  Show Profile  Reply with Quote
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

India
52249 Posts

Posted - 06/27/2013 :  10:28:49  Show Profile  Reply with Quote
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
Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  10:44:34  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/27/2013 :  10:56:03  Show Profile  Reply with Quote
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
Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  10:57:52  Show Profile  Reply with Quote
but it works when I execute in ssis,

Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  11:49:10  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/27/2013 :  12:02:04  Show Profile  Reply with Quote
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
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/27/2013 :  12:03:32  Show Profile  Reply with Quote
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
Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  12:35:35  Show Profile  Reply with Quote
im using WINSCP

Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/27/2013 :  12:49:19  Show Profile  Reply with Quote
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
Go to Top of Page

masterdineen
Aged Yak Warrior

United Kingdom
545 Posts

Posted - 06/27/2013 :  13:02:58  Show Profile  Reply with Quote
will that work for a sftp with a SshHostKeyFingerprint key
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

India
52249 Posts

Posted - 06/27/2013 :  13:32:48  Show Profile  Reply with Quote
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
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.11 seconds. Powered By: Snitz Forums 2000