i wonder if you can do incremental load from MysQL to SQl server 2008. I used ADO .NET source connecting to MySQL and I could not do connection to Script...

hi:

I resolved this problem by resetting flag RetainSameConnect to false for MySQL Connection component in ConnectionManages.

thank you!