Hi,  I am trying to schedule a SSIS package in SQL agent 2005.  I can run the package manually using Business Intelligents Studio but when I try to schedule it the following error orrurs. 

I set it up using windows authentication.  I have administrator rights.

SQL Server Scheduled Job 'TestImport' (0x5EB86F3C24723D41B5C5779C026CCFCC) - Status: Failed - Invoked on: 2007-03-06 09:55:13 - Message: The job failed.  The Job was invoked by User QDSSVR1\bibeaultd.  The last step to run was step 1 (testimport1).

Is this another security issue?  Should I set up using system administrator?

Help!

Newbie

Thanks,  How do you check to see if SQL agent can run a SSIS package?  One more question, does the standard install install SSIS on the server?  How can I tell if all the peices are in place?

thanks,

I am having a similar problem - SSIS package executes fine in BIDS but fails when scheduled as SQL Server Agent job. Different error...

Windows Server 2003/SQL Server 2005 64-bit.

Package Protection - DontSaveSensitive  (prior to this error I was getting a password encryption error so changed to this protection level with new error result)

Error Message Text:

Executed as user: SVHPSQL\SYSTEM. Microsoft (R) SQL Server Execute Package Utility  Version 9.00.3042.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:14:31 AM  Error: 2007-03-06 10:14:32.33     Code: 0x00000000     Source: D_Member Month      Description: This task does not support native Win64 environment. Please run the package in 32-bit WOW environment instead.  End Error  Error: 2007-03-06 10:14:32.35     Code: 0xC0024107     Source: D_Member Month      Description: There were errors during task validation.  End Error  DTExec: The package execution returned DTSER_FAILURE (1).  Started:  10:14:31 AM  Finished: 10:14:32 AM  Elapsed:  0.359 seconds.  The package execution failed.  The step failed.

Hi All,

I used this example to set up my Proxy Account and it has been working fine...

http://www.codeproject.com/useritems/Schedule__Run__SSIS__DTS.asp

Kind Regards

Stefan Ghose

wyliec2,

You need to call out the 32 bit dtexec as opposed to the 64 bit.  It is located here if you installed to the default location: 

"C:\Program Files (x86)\Microsoft SQL Server\90\DTS\Binn\dtexec.exe"

Are you doing anything with ODBC in your SSIS package?  If so, odbc is not supported on the 64 bit platform.  That is the biggest issue we ran into with 64 bit.

Hopefully this helps,
John