Hi,
I tried a really simple data driven query which concatened 2 string fields in 1 and I had this error (0x80042040)
Then I tried without the concatening operation (a direct copy) and got the same error

The source is a OLE driver for DB2 on a IBM iseries AS400 and the destination is a SQL database

I can't find this error number in any of the MS knowledge base (technet, msdn, bol

Can anyone help me
(if you need additional information, please tell me

best regards
Christophe Nie

mail = firstname.name @ fr . abnamro . com

Whilst I cannot recognise the error code from the top of my head.

Things to try

1. Forget DTS. Do you have A.N.Other query tool to query the DB2 source?.
If you do then does your concatenation syntax work there? The source for a
datapump and a DDQ is source specific i.e. in the language of the provider.

2. If #1 works for you then try putting the syntax into a DataPump task not
DDQ and we can then look to see if you are having problems with the DDQ not
the Syntax itself.

3. If concatenation is your only requirement then the DDQ can do this for
you but it is slower that a datapump task in my opinion and provids
functionality you simply do not need.



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Christophe Niel" <anonymous (AT) discussions (DOT) microsoft.com> wrote