Seems like a problem with the actual XML in the package either getting corrupted (often this occurs due to someone trying to fix a problem by editing the XML directly,...

Glad that you posted consumable data, but your existing query has problems if I try to use your declared tables, as the isDeleted field is missing from several of them.  ...

There's a truly easy way to do that.   Add the following to your query:


UNION ALL
SELECT 2000 AS yourexistingfieldname


If there are other fields...

I'm not sure, but I had thought that the execution context for the Agent job mattered, and as Agent jobs run under the auspices of the Agent Service's service account,...

Wow...   I can't say I can ever remember seeing anyone using such an absurdly small server for anything useful.   The server OS generally needs at least 2 GB just to...

Most companies use mixed mode, as performing administrative tasks really benefits from the sa SQL login, and becomes difficult if not provided.  Mixed mode provides both SQL login and Windows...

If you are connecting via a Script Task instead of a Connection Manager, then you just need to be sure both variables are Read accessible to your Script Task, and...

I found a web page with a solution which appears to work, although you may have to re-examine the value you posted.   I had to drop 3 zeroes from the...

I'm not sure what exactly you're asking.   You've provided the algorithm that generates the file name, but then you state:

"I need the attached to end of the URL"