This can easily be done in ssis you can use the file watcher task to watch and see if any change has happened in the directory and get the file...

OK what i want to do is make the test environment a backup of the production environment no development is done on the test unless absolutely necessary.

to make it more simpler let me explain to you the situation.

1 i have a live database running on my production server which is using a database that...

Thanks man you rock!!!

Pritesh2205

Please can you give an example of a script task i will be very grateful of you.

ok thanks to all of you who responded. However; what i want to know is

After i insert the file name and read the content of the file into my...