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...

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...

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...

Patrick Hill-489170 (1/17/2013)

---

Sean Lange (1/16/2013)

---

Patrick Hill-489170 (1/16/2013)

---

I know this is an old thread but figured I would post here instead of creating a new one. I too am having this...

But did you change the...

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?

It actually will also say "See the Job History for details". As I said previously you need open the job history so you...

miles411 (1/16/2013)

---

Our outside vendor changed the name the of what the database warehouse was called recently and since then my users with Access that is link to our internal SQL...

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.

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...

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...

Patrick Hill-489170 (1/16/2013)

---

I know this is an old thread but figured I would post here instead of creating a new one. I too am having this issue. The odd thing...

miles411 (1/16/2013)

---

I am using SQL 2008 server and an external vendor changed the particular warehouse name for the IMPORT file that I was receiving through my SQL server from them....

Well the query that Chris posted returns the exact output you specified. If you need something different you have to explain it. We can't see your screen, we are not...

Take a look at the link in my signature about cross tabs. That article explains how to use pivot in addition to cross tabs.