My "It work well a while ago" moment...
-
Trying my hand on SSIS. Used Script Task, put a little script, and then press F5, it runs without errors. Used Execute Process Task, open psftp,put those little arguments for getting a file somewhere outside the server, then press F5, the Script and the Process Task run no error. Used a file System Task, copy the copied file from the other server to Desktop, pressed F5, then the 3 tools run without any error. (All these 3 are connected) Then I'm trying to run this little package using SQL Jobs. From nowhere, Script Task generates an error! :omg: Now where did it come from? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
Trying my hand on SSIS. Used Script Task, put a little script, and then press F5, it runs without errors. Used Execute Process Task, open psftp,put those little arguments for getting a file somewhere outside the server, then press F5, the Script and the Process Task run no error. Used a file System Task, copy the copied file from the other server to Desktop, pressed F5, then the 3 tools run without any error. (All these 3 are connected) Then I'm trying to run this little package using SQL Jobs. From nowhere, Script Task generates an error! :omg: Now where did it come from? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
Karen Mitchelle wrote:
Trying my hand on SSIS.
Aren't they the militant Muslims taking over Iraq and fighting in Syria?
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
ISIS Sounds like a military force you'd fight for in a flight-sim. In Arabic it sounds much more bond-villan-y: Da'ish (ad)-Dawla Islamiyya fi Iraq wa (ash)-Sham. You can just see the leader of Da'ish stroking a cat now, from his volcano la-yer*. The leader of ISIS is more likely to be giving freedom to oil-rich nations of the world. * Aye - I know.
Alberto Brandolini:
The amount of energy necessary to refute bullshit is an order of magnitude bigger than to produce it.
-
ISIS Sounds like a military force you'd fight for in a flight-sim. In Arabic it sounds much more bond-villan-y: Da'ish (ad)-Dawla Islamiyya fi Iraq wa (ash)-Sham. You can just see the leader of Da'ish stroking a cat now, from his volcano la-yer*. The leader of ISIS is more likely to be giving freedom to oil-rich nations of the world. * Aye - I know.
Alberto Brandolini:
The amount of energy necessary to refute bullshit is an order of magnitude bigger than to produce it.
-
ISIS always sounds like a Scandinavian hedge fund to me.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
Why would anyone save to buy a hedge :~
Alberto Brandolini:
The amount of energy necessary to refute bullshit is an order of magnitude bigger than to produce it.
-
Why would anyone save to buy a hedge :~
Alberto Brandolini:
The amount of energy necessary to refute bullshit is an order of magnitude bigger than to produce it.
-
ISIS always sounds like a Scandinavian hedge fund to me.
Some men are born mediocre, some men achieve mediocrity, and some men have mediocrity thrust upon them.
I thought the Scandinavians always cut their hedges?
-
Trying my hand on SSIS. Used Script Task, put a little script, and then press F5, it runs without errors. Used Execute Process Task, open psftp,put those little arguments for getting a file somewhere outside the server, then press F5, the Script and the Process Task run no error. Used a file System Task, copy the copied file from the other server to Desktop, pressed F5, then the 3 tools run without any error. (All these 3 are connected) Then I'm trying to run this little package using SQL Jobs. From nowhere, Script Task generates an error! :omg: Now where did it come from? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
SQL Agent runs under a different user account, which obviously has different permissions
========================================================= I'm an optoholic - my glass is always half full of vodka. =========================================================
-
Trying my hand on SSIS. Used Script Task, put a little script, and then press F5, it runs without errors. Used Execute Process Task, open psftp,put those little arguments for getting a file somewhere outside the server, then press F5, the Script and the Process Task run no error. Used a file System Task, copy the copied file from the other server to Desktop, pressed F5, then the 3 tools run without any error. (All these 3 are connected) Then I'm trying to run this little package using SQL Jobs. From nowhere, Script Task generates an error! :omg: Now where did it come from? :doh:
Don't mind those people who say you're not HOT. At least you know you're COOL. I'm not afraid of falling, I'm afraid of the sudden stop at the end of the fall! - Richard Andrew x64
-
I thought the Scandinavians always cut their hedges?
-
Quote:
cut their hedges
Isn't that some sort of euphemism?
- I would love to change the world, but they won’t give me the source code.