Hi,

I am using sql server integration services(SSIS) in sql server business intelligent devolopment studio.

I need to do a task --that is.

I have to read from a source database and put it into a destination flat file.But the same time the source databse should be configurable.

That means in the Oledbconnection manager connection string should change dynamically.this connection string should be taking from a configuration/xml/flat file.

I read that i can use varaibles and expressions to change the connection string dynamically.But how do i read connection string value from a config/xml/flat file and set the variable?

This part i am unable to do.Or is this the right way to achieve this..

Can we add web.config files to ssis project.?

I am new to SSIs.

Please provide some help with examles etc. and this is quiet urgent for me.

Thanks

SNA.