Is it possible to connect to MySql using SSIS?Mr Shaw

Of course,just download the .NET Provider for MySQL here and install it. Then, add a ADO.NET Source component to your package, right-click on it, and select Edit.. . In the Connection Manager tab of ADO.NET Source, click on NEW button beside ADO.NET Connection Manager drop down list, which opens Configure ADO.NET Connection Manager window. Click New.In the Connection Manager window, click on the arrow beside Provider drop-down, and select .NET provider for MySQL from the list. You can continue developing your package then. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

http://www.ideaexcursion.com/2009/06/04/howto-connect-to-mysql-in-ssis/

Of course,just download the .NET Provider for MySQL here and install it. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com Will i be able to use it with an OLEDB connection manager?Mr Shaw

check this msdn blog for Connecting to MySQL from SSIS.. Let us TRY this | My Blog :: http://quest4gen.blogspot.com/

Of course,just download the .NET Provider for MySQL here and install it. Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com Will i be able to use it with an OLEDB connection manager? Mr Shaw You need to use ADO.NET Source component.Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Yes it is possible. Please refer this link: http://blogs.msdn.com/b/mattm/archive/2008/03/03/connecting-to-mysql-from-ssis.aspx --Senthil