Viewing 15 posts - 9,811 through 9,825 (of 13,880 total)
var05 (6/19/2013)
Thanks for your reply,Yes the account under which the sql agent jobs runs also has permissions to the shared folder. but the job is still failing. Any help?
Thanks!
Sorry to...
June 19, 2013 at 4:13 am
The SSIS temp table 'hack' is described here[/url]. A relatively straightforward publication of meta data does the job.
In 2012, the hack changes, but given the forum, I'm assuming that you...
June 18, 2013 at 1:14 pm
Are you selecting from a temp table in your process? Does your process have set nocount on at the top?
June 18, 2013 at 10:33 am
andy.westgate (6/18/2013)
Good to have that confirmed. It was the lack of mapping between the DFT and the Exceil destination that was throwing me but I have a couple of...
June 18, 2013 at 8:18 am
andy.westgate (6/18/2013)
This is also the problem I am having.
I want to execute a stored proc and output the results to...
June 18, 2013 at 7:58 am
Running out of ideas, I'm afraid. You are right in thinking that there is not normally any need to mess about with built-in assemblies.
June 17, 2013 at 7:49 am
Do you have SSIS installed too?
June 17, 2013 at 7:11 am
Script tasks and script components are different things - which one do you mean?
June 17, 2013 at 4:47 am
Do you have anything on the resultset tab?
Edit - well done on solving it.
June 14, 2013 at 8:46 am
Try putting
SET NOCOUNT ON
at the top of your proc.
June 14, 2013 at 8:26 am
swetha.prachi (6/14/2013)
The data in the file is encrypted and we need to decrypt it
Do you know how to do it with execute process task?
Thanks,
Swetha
Taking SSIS out of the equation, do...
June 14, 2013 at 2:45 am
mrichardson 57577 (6/13/2013)
If I was selecting just 1 column in a simple query it would probably work, but...
June 13, 2013 at 9:28 am
I never said it was a good idea - Gail's answer would have been mine too.
June 12, 2013 at 6:34 am
$w@t (6/12/2013)
I am not going to use it anywhere..I faced this Question in interview..so i posted here
I Just want to...
June 12, 2013 at 5:57 am
$w@t (6/12/2013)
Hi,Can we call stored Procedure inside a function
Thanks
Why did you ask this question, when you already believed you knew the answer?
Would you consider implementing the method shown...
June 12, 2013 at 5:30 am
Viewing 15 posts - 9,811 through 9,825 (of 13,880 total)