Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter › Re: Connecting BizTalk to MySQL with BTS2K6 Dynamic ODBC Adapter
September 13, 2006 at 4:25 AM
#15671
Rather than use the windows schedule task, you could try the Scheduled Task Adapter.
http://www.gotdotnet.com/Community/UserSamples/Details.aspx?SampleGuid=E473FC93-5081-44C7-A9C9-84BF4E783728
You could use this to initiate an orchestration that will call a .NET class to access MySQL.
Or you could call your .NET class from this adapter. It requires two classes, one to define your config properties like connection string and query and the second implements the MySQL access and returns a stream.