Parameter values are assigned before the package starts executing and are read only during execution, so what you are asking is not possible.

Yes, that is not a domain account. Does that local account have the necessary rights to create files on local drives?

For the purposes of testing (and don't forget to change...

Here is a grossly inelegant solution that I knocked up quickly. Others will no doubt come up with something nicer to look at!

DROP TABLE IF EXISTS #Names;

CREATE...

Is SSIS dev in 2019 now working OK? I had assumed it would not be roadworthy until sometime next year, based on experience.

It's starting to sound like a software update issue. On a test...

Can you reproduce the error locally?

I suggest that you collect the execution plans for the slow and fast versions and compare them. The comparison should provide clues about what's going on and how to fix...

Please post back when you find out the reason. It's an interesting one.

Sorry Phil.

My questions are:

<li style="list-style-type: none;">

1. Why would I get Load_Dte as local time when run from Desktop and UTC when run from server?

<li style="list-style-type: none;">

1. How...

And your question is ...?

1. Is this a problem?
2. Can I make all times UTC?
3. Isn't this great? I thought you'd all like to know.
4. Do you know why this...

Nothing has changed anywhere

Something has changed, somewhere, or this would not happen. Server o/s update, .NET update, underlying data, permissions, other software installed, ...

Is this a blog post, or do you have a question?

I wonder whether I will be cast out from The Thread as a maverick grammar nutjob for suggesting that NSO would be a better abbreviation, given that 'verbal' means pertaining...

It is necessary (dictated by vendors) to be able to manipulate Excel files like renaming Sheets and in the example above, saving the Workbook in a text format.

Any...

• This reply was modified 6 years, 7 months ago by Phil Parkin.

I am so sorry. I clicked on Report by mistake, instead of Quote.

If you look at the list Services running on the server, in the Log On As column, you...