Discussion on:

Execute SQL statements in Integration Services

we are transitioning from DTS to SSIS; it is great, but I'm stuck on what should be an obvious point - I simply need to query for a maxID in the target table, and use this value as the WHERE criteria for the MySql import query. Have not arrived at the solution...please advise 8^) I greatly appreciate it