If you are trying to use MySQL migration toolkit and unable to install the MySQL odbc connector because of error 1918 as below, use below steps.

1) Install Microsoft Visual C++ 2010 Redistributable Package

http://www.microsoft.com/en-us/download/confirmation.aspx?id=14632

2) Re-install the MySQL ODBC Driver

To take a backup of massive MySQL database, it is suggested to use an application that compresses the backup like 7Z or gzip and use MySQLdump utility placed in bin folder.

Please feel free to download gzip at gzip-1.3.12-1-bin

Imagine a situation where you are processing all files in a folder and few files need not be processed in SSIS.

Here are the steps:

1. Configure for each loop container to iterate thru a folder and store each file name in a variable (say FileName)
2. Use execute SQL task and then connect to the data flow task. Connect and use expression & constraint and use expression as follows

[cc lang=”SQL”]

findstring(@FileName, “2012-10-14”, 1) == 0

[/cc]

3. Also use a file system task to move the processed file to Archive folder

4. Even better if you can use checkpoint to start the package from the point of failure