david.ostrander (12/2/2011)

---

Sorry about that...

My SSIS package pulls data from table (A) and inserts it into table (B) on another sql server.

Our users pull that data from table (B) into excel...

I don't understand this bit: "..pulls data like it should sho users can report off of it in excel." - is there a typo in there somewhere? It doesn't make...

What is the parent of this property - an ExecuteSQL task?

The easy way to find which column is the problem is to change the Insert statement into a Select Into using a temp table as the target, then compare the...

davidandrews13 (12/2/2011)

---

sure:

it runs a Stored Procedure to get back a set of data.

it then cycles through that set of data, opening a Web Service and passing the data through one...

Can you summarise what the app is supposed to do?

I think you might have more success if you create a console application to do this and then just run the .exe that that produces from within SSIS.

Please post the full text of the error message.

That's more than I have!

jnichols-797753 (11/30/2011)

---

T hanks. I was expecting this reply but hoping someone had found a secret MS was holding back on. I wonder if there is a need for...

Jeff - that's a great idea.

Mr. Holio (11/30/2011)

---

Hi all,

Can someone pls help me with the following? I'm trying to to do a few tests and to use PIVOT (for the first time) but couldn't get...

Yes I did. And which...

Are you looking in the right place? Check attached screen shot to confirm.

Agreed with this and with your previous post: if there...