For future info.

With the simple stuff, you should find it's faster to Google and use what's already been written than writing out a post and waiting for people to respond.

herladygeekedness (12/12/2011)

---

Can't use a script task, this is in the data flow. I cannot just update or merge join.

Specifically, I have payments that must be attributed to...

That's not a link. This is a link

😛

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