Hello guys, I have fix most of my problems and use a key to encrypt the password The data comes from a AS400 to a sql server r2 server. But I am getting this error and sadly I cant find a answer to this. Date 04/11/2010 12:39:35 Job History Record (SSIS Test) Step 1 ID Server AUAE015705 SSIS Job Name Test Step name Test1 Duration 00:00:01 SQL Severity 0 SQL message ID 0 Operator notified by email Notified operator network by sending Operator notified by pager 0 retries made Message Executed as user: AUAE015705 \ SYSTEM. The step did not generate any output. Package execution error. Could not make the transition. Anyone got a idea for this.

Hi Enrique A_ , You need to provide more details on what this job does. Does it execute T-SQL or does it execute a SSIS package? The more details, the easier to identify the problem Sergei

Ohh sorry its a SSIS package that copy data from a AS400 to another server from a dataware to a test server.

is pkg on file system or on SQL SERVER?? Gaurav Gupta http://sqlservermsbiblog.blogspot.com/

you mean the dstx file (The package?) I have try both ways and end getting the same result.

Hi Enrique A_, Does the package run fine in the Business Intelligence Development Studio(BIDS)? Thanks, Jin ChenJin Chen - MSFT