Thanks Balaji for the code.

hi, i took a breather and analyzed my code again. i overlooked some syntax. i must be working too many long hours.

thanks!

Hello, I'm in a same dilema today with SQL 2008. I tried your advice using dynamic SQL in replacing the 'data_file' part of the OPENROWSET. Here is part of the...

I checked the components of the SSIS package. I was wrong about the Job not finishing. The Job actually starts but doesnt go thru the tasks.

Still cannot figure...