Hi!
I have a SSIS package that transforms three tables from a SS2000 server to
my new SS2005 server. The connection to the sourceserver uses SQLServer
credentials with userid and password. Destinationconnection uses windows
authentication.
The package runs perfectly in BIstudio aswell as when I manually Execute
package in SSManagment Studio!
BUT: When I try to execute the package as a scheduled job under SQLServer
Agent it doesn't :-( It doesn't matter if I start the job or let my Agent
account start it on schedule. It fails almost imidiatly whith almost no
information:

Date 2006-03-06 13:42:24
Log Job History (Transfer tables from Navision to DWSrc)

Step ID 1
Server SRV009A
Job Name Transfer tables from Navision to DWSrc
Step Name Load G/L Account
Duration 00:00:02
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0

Message
Executed as user: ABC_NET\sqlAdmin. The package execution failed. The step
failed.

The account that runs SQLAgent is in local administrators group, and is in
System Admin serverrole.

Anyone who got an idea how to handle this?

Best, Jocke

First step would be to execute the package usinng the command-line subsystem
rather than the SSIS execution subsystem. Here's why:
http://wiki.sqlis.com/default.aspx/S...dPackages.html

-Jamie

"Jocke" wrote:

First step would be to execute the package using the command-line subsystem
rather than the SSIS execution subsystem. Here's why:
http://wiki.sqlis.com/default.aspx/S...dPackages.html

-Jamie


"Jocke" wrote: