Calling SSIS from SQL Server Agent Doesn't Run No Error Given

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » SQL Server Agent » Calling SSIS from SQL Server Agent Doesn't...

Calling SSIS from SQL Server Agent Doesn't Run No Error Given

Rate Topic

Display Mode

Topic Options

Author

Message

Margaret Norkett

Posted Thursday, January 29, 2009 9:32 AM

Grasshopper

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. w00t

Thanks and have a NICE day!,

Margaret

Post #646080

mariekaldjob

Posted Thursday, September 29, 2011 8:28 AM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, September 05, 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

Naeblis

Posted Wednesday, February 01, 2012 8:45 PM

Forum 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 »

Permissions