Hi,

I am in the middle of creating a dts in SQL 2005 which needs to push data to
a MySQL database. I am able to create a datasource connection in solution
explorer and then add it to the connection managers, but am struggling with
setting the connection in the 'DataReader Destination'.

There is no option for selecting a connection as you do with 'OLE DB
Destination', therefore I don't know when the data is actually going.

Does anyone have any ideas?

Thanks in advance!

Since SQL 2005 is still in beta, you'll want to post this in the Community
Newsgroups:

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

--
--Brian
(Please reply to the newsgroups only.)


"enzat" <enzat (AT) discussions (DOT) microsoft.com> wrote

Thanks Brian,

I'll post it straight away.

"Brian Lawton" wrote:

BOL has a good explantion as to why you cannot see to where the data is flowing and here
it is

"The DataReader destination exposes the data in a data flow by using the ADO.NET
DataReader interface. The data can then be consumed by other applications. For example,
you can configure the data source of a Reporting Services report to use the result of
running a Microsoft SQL Server 2005 Integration Services (SSIS) package. To do this, you
create a data flow that implements the DataReader destination."


Allan

On Wed, 31 Aug 2005 18:33:03 -0700, "enzat" <enzat (AT) discussions (DOT) microsoft.com> wrote:


Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know