Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Calling SSIS from SQL Server Agent Doesn't Run No Error Given Expand / Collapse
Author
Message
Posted Thursday, January 29, 2009 9:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Thursday, August 20, 2009 5:37 AM
Points: 11, Visits: 26
I call an SSIS package with a SQL Server Agent Job.

The first "step" in the SSIS package is to move files from one folder to another. This step never executes. The next tasks are to generate a new file and ftp that file to a location. This part seems to work.

Why isn't the first task executed from the SQL Agent job?

This job never reports an error.




Thanks and have a NICE day!,

Margaret

Post #646080
Posted Thursday, September 29, 2011 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, September 5, 2012 8:48 AM
Points: 1, Visits: 5
Hi,

I call an SSIS package from Job SQL.
The job is 'success' but, data are not populated in my tables;
I use the SQL Agent for running the Package.
Can someone helps me about that?
Post #1183198
Posted Wednesday, February 1, 2012 8:45 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Saturday, June 16, 2012 4:52 AM
Points: 2, Visits: 21
SSIS jobs must use a proxy

create a proxy.
map the proxy to credentials
select proxy in drop down in agent job

profit

Naeblis
Post #1245441
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse