|
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! 
Now where did it come from? 
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 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.
|
|
|
|
|
Scandinavians... 
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?
|
|
|
|
|
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.
|
|
|
|
|
Actually, cutting the "hedge" is nor very common in Scandinavia. It is mostly limited to certain non-Christian religious groups.
That euphemism is quite new to me, though.
|
|
|
|
|
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.
=========================================================
|
|
|
|
|
Karen Mitchelle wrote: Desktop
The SQL agent doesnt create a desktop session. All about the context...
Common sense is admitting there is cause and effect and that you can exert some control over what you understand.
|
|
|
|
|
|
Were you trying to navigate to a page with information about Windows 9? 
Soren Madsen
"When you don't know what you're doing it's best to do it quickly" - Jase #DuckDynasty
|
|
|
|
|
Ab-so-lutely brilliant!  
Those who fail to learn history are doomed to repeat it. --- George Santayana (December 16, 1863 – September 26, 1952)
Those who fail to clear history are doomed to explain it. --- OriginalGriff (February 24, 1959 – ∞)
|
|
|
|
|
Yes, and it lets you reply to it too.
|
|
|
|
|
Really, I have to give that a go 
|
|
|
|
|
Perfect!
Anything that is unrelated to elephants is irrelephant
Anonymous
-----
The problem with quotes on the internet is that you can never tell if they're genuine
Winston Churchill, 1944
-----
I'd just like a chance to prove that money can't make me happy.
Me, all the time
|
|
|
|
|
Seems that Marvin got a new job.
|
|
|
|
|
My ex finally got a job?
As I grow older I've found that pleasing everyone is impossible but pissing everyone off is a piece of cake.
|
|
|
|
|
So, Marvin the Paranoid Android lives (again!)... 
|
|
|
|
|
Nagy Vilmos wrote: and just wait.
Or "View Source" and scroll down 
|
|
|
|
|
Very nice!
/ravi
|
|
|
|
|
Great humor!
"Go forth into the source" - Neal Morse
|
|
|
|
|
|
"Double crosses one against first school uniform all the time."(6-4,5)
Best of luck
---------------------------------
Obscurum per obscurius.
Ad astra per alas porci.
Quidquid latine dictum sit, altum videtur .
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
