Hi..
I have a package that uses script task. This task basically outputs XML data into a SSIS variable. The package runs perfectly on BIDS, moving data correctly. But when I run it on job agent, I can't see any data transfer. Which means the output SSIS variable is empty.
Anybody has an idea why this is happening?
Thanks