Thank you Howard!

Cadavre (12/12/2011)

---

Phil Parkin (12/12/2011)

---

Thanks, but that returns the current user - not quite what I am after.

I want the name of the user which is running the SQL Server service...

Thanks, but that returns the current user - not quite what I am after.

I want the name of the user which is running the SQL Server service for the particular...

Elliott Whitlow (12/9/2011)

---

Wow, thats an interesting request.. I question the methodology but ok..

I would use a data-flow task. The rows are generated by a source and a script...

Is there a longer error message available?

Does the package ever fail when run in Visual Studio?

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