Re: SQL Server 2005 DTS with DB2 source

#1

In message <B46771E3-0B2C-4370-9918-FDFB04B94A42 (AT) microsoft (DOT) com>, Zoran
Pecenovic <ZoranPecenovic (AT) discussions (DOT) microsoft.com> writes

Quote:

Hello,
I am not sure whether this is the right place to post this question, so
please re-direct me to the more adequate forum if its not...

We have installed the SQL Server 2005 Beta 2 for evaluation and I have
set-up a simple DTS package that will connect to one of our DB2 sources
(using Microsoft OLD DB Provider) and dump the data to a flat file.

The test connection in the data links works fine.
Invalid queries produce DB2 errors (as I would expect),
*BUT* any valid query (valid on DB2 system) that I write through the "OLEDB
source Editor" produces the following error:

Error at Data Flow Task [DB2 DW [664]]: There is a data source column with
no name. All data source column must have a name.

I tried even simple things like "select tabname from sysstat.tables"

Thanks for any help or pointers,

Zoran

Sorry I cannot help, but I can tell you the best place to ask this is in
the beta NG (microsoft.private.sqlserver2005.dts)

http://communities.microsoft.com/new...=sqlserver2005
&slcid=us

Server: privatenews.microsoft.com
Account name: privatenews\sql05
Password: feedback

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: SQL Server 2005 DTS with DB2 source

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Re: SQL Server 2005 DTS with DB2 source - 08-17-2004 , 01:05 PM