2005 Integrated Services - 08-31-2005 , 08:33 PM
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!
Re: 2005 Integrated Services - 08-31-2005 , 09:30 PM
Since SQL 2005 is still in beta, you'll want to post this in the Community
(Please reply to the newsgroups only.)
"enzat" <enzat (AT) discussions (DOT) microsoft.com> wrote
Re: 2005 Integrated Services - 08-31-2005 , 09:43 PM
I'll post it straight away.
"Brian Lawton" wrote:
Re: 2005 Integrated Services - 09-01-2005 , 12:33 AM
BOL has a good explantion as to why you cannot see to where the data is flowing and here
"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."
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