Hello Phil,

Thank you for the response.

After reading the following blog,

http://sqlblog.com/blogs/jamie_thomson/archive/2010/11/13/ssis-server-catalogs-environments-environment-variables-in-ssis-in-denali.aspx

and you suggested,

I require to create one project along with the 3 packages in it.

The folder path from where I'm going to read the CSV files should be configured as project parameter.

This can be changed at SQL server level with environment variable.

Is this correct?

One question:

1. For package 2 can I use Bulk insert task. According to my knowledge bulk insert task does not support logging of data (if any of the rows in CSV file gets failed during import, it cannot be logged).

Can Package execution logs help in that context?

Also can you please revert on other questions that I've asked in previous message. Thanks.