The exact error is as follows:

An error occurred during the execution of xp_cmdshell. A call to 'LogonUserW' failed with error code: '1326'

I don't think its a syntax issue there. Sounds...

Try both of your suggestions. No sucess.

Yup.

Used Derived Column Transformation and got the substring of the desired length on all the columns.

Package ran sucessfully.

Thanks for the help.

Column widths are correct. Column 0 contains 5659 for all the rows. I don't see any special character in this column to cause problem.

Any comments/suggestions guys?

In one way or the other I need to use qualifier. If I run on SSIS Execute SQL TASK (AS400 Connection), I don't need to specify ASWTEST.S1012A5C. I can just...

ASWTEST is servername

S1012A5C is catalog name

IC1480BFPD is Library name

Then Table Name, Column Name.

BTW Librayname.ColumnName is attached.

When I run simple select statement, it runs with 5 qualified names...It doesn't run with...

Thanks for your patience working with me. Its been a huge pain. I ran the two pieces seperately and still erroring out

SELECT [DataWarehouse480].[dbo].[Temp_SalesRep].XUBRNAM

FROM [DataWarehouse480].[dbo].[Temp_SalesRep]

WHERE [DataWarehouse480].[dbo].[Temp_SalesRep].XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB.XUBCUNO

ERROR:failed with...

BTW, I have removed the spaces between the table qualifier and column. Still same issue.

SELECT XUBRNAM

FROM [DataWarehouse480].[dbo].[Temp_SalesRep]

WHERE [DataWarehouse480].[dbo].[Temp_SalesRep].XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB.XUBCUNO

AND EXISTS

(SELECT 1 FROM [DataWarehouse480].[dbo].[Temp_SalesRep] WHERE...

Tried the following SELECT based on your suggestion. Erroring out.

SELECT XUBRNAM

FROM [DataWarehouse480].[dbo].[Temp_SalesRep]

WHERE [DataWarehouse480].[dbo].[Temp_SalesRep].XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB.XUBCUNO

AND EXISTS

(SELECT 1 FROM [DataWarehouse480].[dbo].[Temp_SalesRep] WHERE [DataWarehouse480].[dbo].[Temp_SalesRep].XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB .XUBCUNO)

ERROR:

failed with...

Sure did. Same error.

UPDATE ASWTEST.S1012A5C.IC1480BFPD.XROHUB

SET XUBRNAM =

(SELECT XUBRNAM

FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1

WHERE T1.XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB .XUBCUNO

AND EXISTS

(SELECT 1 FROM [DataWarehouse480].[dbo].[Temp_SalesRep] T1 WHERE T1.XUBCUNO = ASWTEST.S1012A5C.IC1480BFPD.XROHUB .XUBCUNO))

No. Still the same error persists.

Token SET was not valid. Valid tokens: . SQLSTATE: 42601, SQLCODE: -104". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters...

Sorry. The error I posted earlier might not be relevant. That was run on query analyzer.

Here is the exact error message when I tried to run the queriy in SSIS...

Thanks guys. I am almost there. I added a linked server to AS400 and can easily bring the AS400 table in the join and find the record that do not...

SQL server 2005