Thanks. The db is DB2 and I need to have this done in SSIS as we are not allowed to customize on the db side.

thanks.

Were you able to resolve this issue. I'm having the same problem. Anybody have any suggestions?

Thanks.

OK! got it to work. I have a File Task to copy a template over to my destination in a package. Then another package that has an Execute SQL Task...

Born2bongo,first off thanks for your suggestions.

I tried both - 1. creating the file system task to copy the template( and using this new file as the destination) and 2....

test