SSIS Package Scheduled as a Job

[JulesDBQ]

Hi,

I am having an issue trying to get an SSIS package to run as a job in sql 2005.....

All the package does is import a flat file into an existing table. Manually executing the SSIS package works every time, but running the package as a job causes a failure each time.

Does anyone have any ideas??? Please advise...

Error message is as follows:

Date 3/5/2007 4:28:32 PM
Log Job History (CCURE_Step2_ImportDailymass)

Step ID 1
Server SQL1\SECURE
Job Name CCURE_Step2_ImportDailymass
Step Name ImportDailymass
Duration 00:00:01
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: ADM2-ERIE\MySqlC. The package execution failed. The step failed.

 

[mrdenny]

Log into the SQL Server with that account and try to run the package from the command line. This will give more information.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com