MySQL to MS SQL 2005 by ADO.NET RRS feed

  • Question

  • I've a SSIS package which pulls data from MySQL to MS SQL 2005; it ran fine in MS Visual Studio when first develop.  After exit MS Visual Studio and re-open the package, now it does not.  It just hang at the DataSource Reader data flow task.  On the Connection Manager window, I noticed the Password field under Misc tree is blank.  When I re-enter the password and test connection, it succeeded; click OK to close the window, when re-open the connection the password is blank again.  Is the blank password causing the package hang? 





    Thursday, April 24, 2008 12:00 AM