question

Nick_M avatar image
Nick_M asked

SSIS Schedule not picking up xml config parameters.

Hi, My package works fine in BIDS, but when I deploy & schedule the package to run in SQL Server 2008, It does not seem to reference the variables that have been changed in the xml config file, although I have referenced the xml config file in the scheduled job.

ssisschedule
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Rob Farley avatar image
Rob Farley answered

Can you confirm that the file you're referencing for your config is definitely the same one you've changed? Last time I came across something like this, it ended up being my stupid error...

If you change the name of the file on the file system, does the job complain at you?

What if you use dtexec, grabbing the command line parameters out of the job?

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.