Thanks!

Koen Verbeeck (2/7/2012)

---

Khades (2/6/2012)

---

I have a name column coming from my source. I need to get the ID for each name. The table in which the name and ID columns...

Ok, looks like the compatibility level of some databases are set to 2005, found the issue, thanks!

I ran your script in 4 environments and it only passes in 1 without the Z, it passes all with the Z.

Can this be server version issue?

10.0.2734 Fails

10.0.2757 Fails

10.0.4000 Passes

10.0.5500...

There is only 1 stream per data flow, but 20 data flows.

Yes but I think doing a foreach loop on the resultset will probably be the same as the OLE DB command as far as performance goes.

GSquared's suggestion of calling the...

This is only a staging table. The bigger problem is the database where we get the information to stage in this table. The whole database is full of EVP/NVP tables...

Yeah, thanks! I couldn't have done it without you.

2 Small tweaks made it work, thanks!

In case anyone cares the code is below. I added a partition by to the ranking function, and also added an additional join condition...

Thanks again GS!!

Thanks everyone!

It wasn't an absolute requirement to avoid creating a new data type. I just wanted to avoid it if I could.

Apparently I had table variables and table valued input...

Oh my. I'm truly embarassed. :blush: I lost track of this thread and didn't see your wonderful comment. My apologies and thank you very much. It's...

Oh wow, I did not know the magic tables would have that identity even if you don't directly insert/update/delete it, thanks!

As always, thank you Koen.

Or Maybe even use the name of the connection string itself. Is there a system variable that holds that information?