Hi,

here a remark to the first solution. All thoughts concer the case of setting @carrier to null.

Since isnull creates an identity for carriertrackingnumber, the original query will return all rows...

Hi Wildster,

thank you for your hint. It might be the real solution for the problem, due to the fact that there is no correct drive mapping for the system account.

Unfortunatly...

@steveb-2:

Hmmm... I think i will end up in a similar procedure since i found no thread matching my actual problem exactly.

@all

Thanks for your efford.

@da- zero:

There is no chance to write even one line of code because the VSA doesn't open even wehen i try to create a new script component. And yes the...

@da- zero:

Meanwhile i tried to create a new script component and got the same error. So it is definitely no problem with the source code contained in the script component.

@da- zero:

Why should plain text cause a problem while opening VSA? Further more i was able to edit the source code of any script component some time ago.

Hi da- zero,

there is no code involved that i created manually. The message is shown from the edit dialog of an script component when i press the button "design script"...

@Bhuvnesh: Thanks for your effort. Now the links work.

@all: The problem was solved by realising a second job that monitors the runtime of the productiv job. If the...

Thanks for your reply.

Unfortuntaly the link you sent is broken or poits to an closed area.

Regards

Gregor

Hi,

acutally i'm loking for a solution for a similar problem. Did you solve yours?

Regards

Gregor

@nahk.fussuy: Many thanks for your tip

Regards

Gregor

Hi,

i've the same problem, but created an credential and a proxy for the sql agent to run the package under the account the package was created.

So there should be no...