kk.86manu (12/6/2011)

---

Hi All,

When SSIS loads data from the text file,are all fields read as string data types, even if they contain integers?Should we convert the data before loading?

Please let me...

MostInterestingMan (12/5/2011)

---

Hi,

I have a package that pulls a csv file from a client's ftp server daily and load into a sql table. I want to be able to check if...

Yes, if there exists a user with sufficient technical know-how...

I knew I should have 'Quoted' that to prove my sanity!

The originally posted query looked like this:

SELECT p.phoneno, mf6_telmn AS TelID, mf6_lcno AS Schedule, mf6_stad1 AS Address, StatusCd

FROM payphone p...

You have two WHEREs - the first one should be ON.

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