Load Data Infile and SSIS variable

[Q Zee]

Hi,

I am migrating a mssql database to mysql through ssis. For the big tables I am dumping all the data to csv file for performance reason. I can hard code the file path and load into mysql just fine. But I like to define the file name and path in a ssis variable and use the variable in a sqlstatement of a sql task. Can anybody point to me to the right direction? I couldn't find any useful info on the web.

Thanks so much
QZ