I'm sorry to say that we haven't done anything on this yet! We have an SSIS package that produces 86 output files, and learned too late that we could have...

Thanks for your reply! Can you help me with the script and the step-to-step on how to complete this? I am a biginner, and things look daunting! Thanks.

Thank you for your response. I replaced my method with yours, and I have the same error.

Here is my resulting script...

USE DS_DEV

GO

DECLARE@TableNVARCHAR(MAX)

DECLARE@filenameVARCHAR(MAX)

SET@table= 'MAMI.EngravingsForVendor'

SET@filename= '\\OMSBVLSTO\Programming\EngravedProducts.txt'

IF OBJECT_ID(@table) IS NOT...