Viewing 15 posts - 9,601 through 9,615 (of 15,381 total)
Agreed. If you can provide more of the code we will have a better chance at an answer.
January 17, 2013 at 3:47 pm
I would highly recommend you NOT use a cursor for this. You should instead use a tally table. You can read about them, how to set it up and use...
January 17, 2013 at 3:43 pm
The easiest way to test it is to run your query (of course removing the insert part) in SSMS. Once you can get the data with your query, your package...
January 17, 2013 at 9:06 am
I would like to have an interface like:
special_replace(@string, 'abcdefgh','12345678')
where all the 'a' get replaced by a 1,
all be 'b' get replaced by a 2, etc.
or
special_replace2(@string, 'aaa|bb|c|d|e|f|g|h','11|2|3|4444|5|6|7|8')
where the 'aaa' get's replaced...
January 17, 2013 at 9:00 am
Often times a cross tab will out perform the pivot function. Take a look at the links in my signature about pivots and cross tabs. Those articles will explain the...
January 17, 2013 at 8:36 am
Patrick Hill-489170 (1/17/2013)
Sean Lange (1/16/2013)
Patrick Hill-489170 (1/16/2013)
January 17, 2013 at 8:27 am
miles411 (1/16/2013)
The server name did change from something else to the the name "ciw_prod" I made the change in the step file and it still failed.
But did you change the...
January 17, 2013 at 8:20 am
It seems you don't have a linkserver named "ciw_prod" in your system. Did the name of the link server change? Was it deleted?
January 16, 2013 at 3:24 pm
miles411 (1/16/2013)
It stated: "Quit the job reporting failure"
It actually will also say "See the Job History for details". As I said previously you need open the job history so you...
January 16, 2013 at 3:20 pm
miles411 (1/16/2013)
January 16, 2013 at 3:18 pm
If you open the Job History for this job it will show you the step details. Go to the step that failed and look at the error message.
January 16, 2013 at 3:09 pm
You are going to have to provide some details. We can't see your screen and we have no idea what this is doing. You said something about the file name...
January 16, 2013 at 3:07 pm
The bigger question is what do you hope to gain by encrypting the procedure code? I doubt you are doing anything so revolutionary that you need to protect how you...
January 16, 2013 at 2:55 pm
Patrick Hill-489170 (1/16/2013)
January 16, 2013 at 2:50 pm
miles411 (1/16/2013)
January 16, 2013 at 2:42 pm
Viewing 15 posts - 9,601 through 9,615 (of 15,381 total)