SSIS Package deployed - Fails when executed from schedule

Posted by alex on Stack Overflow See other posts from Stack Overflow or by alex
Published on 2010-03-19T18:43:40Z Indexed on 2010/03/19 19:31 UTC
Read the original article Hit count: 159

Filed under:

ssis

I've deployed a SSIS package to my SQL server. I can run the package fine by connecting to Integration Services in SSMS and right clicking on it and choosing "Run Package"

However, if I schedule the package, it fails. It tells me to check the logs for information on why, but there is nothing in there...

Any ideas?

(this is my first SSIS package by the way)

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

as seen on SQL Blog - Search for 'SQL Blog'
When you install SQL 2008 R2 workstation components you get a newer version of BIDS (BI Developer Studio, included in the workstation components) that replaces BIDS 2008 version (BIDS 2005 still live side-by-side). Everything would be good if you can use the newer version to edit any 2008 AND 2008R2… >>> More
Parsing flat files using SSIS : SSIS Nugget

as seen on SQL Blog - Search for 'SQL Blog'
Often when using SQL Server Integration Services (SSIS) you will find there is more than one way of accomplishing a task and that the most obvious method of doing so might not be the optimal one. In the video below I demonstrate this by way of an experiment using SSIS’s Flat File Source component;… >>> More
Introducing SSIS Reporting Pack for SQL Server code-named Denali

as seen on SQL Blog - Search for 'SQL Blog'
In recent blog posts I have introduced the new SSIS Catalog that is forthcoming in SQL Server Code-named Denali: What's new in SSIS in Denali Introduction to SSIS Projects in Denali Parameters in SSIS In Denali SSIS Server, Catalogs, Environments and Environment Variables in SSIS in Denali… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More
New SSIS tool on Codeplex – SSIS Log Analyzer

as seen on SQLIS - Search for 'SQLIS'
I stumbled across a new SSIS tool on Codeplex today, the SSIS Log Analyzer which was only released a few days ago. Whilst it is a beta release and currently only supports 2005 (2008 is promised) it looks quite interesting. It seems to be a fancy log viewer, but with some clever features and a nice… >>> More

Developer IT

SSIS Package deployed - Fails when executed from schedule - Developer IT

SSIS Package deployed - Fails when executed from schedule

ssis

Related posts about ssis

SSIS packages incompatibilities between SSIS 2008 and SSIS 2008 R2

Parsing flat files using SSIS : SSIS Nugget

Introducing SSIS Reporting Pack for SQL Server code-named Denali

New SSIS tool on Codeplex – SSIS Log Analyzer

New SSIS tool on Codeplex – SSIS Log Analyzer

Categories cloud