I found the following youtube video by Microsoft technical writer showing how to create a lookup against a cached referenced data set. http://www.youtube.com/watch?v=FB5OPkGsDtA

It shows how to create a lookup...

Before you eliminate the #temp table, take a look at this link and see if it's ideas help solve the #temp table issue.

http://www.sql-server-performance.com/2013/temp-tables-ssis/

As far as the error message, I will...

I'm not saying you can't execute a sproc as a sql statement but I've never done it. Why don't you just extract the sql out of the sproc for the...

awesome. Thanks. I will learn this thanks to your showing me the way. I appreciate it.

hmmm. the create index is for a temp table I don't see referenced anywhere else (I see #ID and #EID)

Can you remove...

I have another CASE statement, similar but different, with which I am struggling.

Here's the case statement:

, AcctNum = CASE

When [Obj Acct] = 0 then [Sub]

When [Sub] = 0 then [Obj...

Hi BlackGarlic,

First, my advice is that you post this to the T-SQL forum because this one on SqlServerCentral is for Integration services (SSIS) which is not as frequently visited as...

Vikash, thanks a lot.

I put it in that way and Derived Column Transformation Editor 'accepted' it, meaning the Expression went black. I haven't run the SSIS package yet, but...

Thank you Sean and Steve!

Bhaskar, thanks for input. I think the problem in this case was that I am concatenating a string value ie. '.' with a different datatype and everything has...

Thank you Kingston. Missed converting those two column references to varchar.

sounds like a paraphrase of error message. I don't get your point.

There's an int I've cast as varchar so that I can concatenate with '.' and num2 which I've also...

Careful thought before I ask the following:

Would it be ok with you not to post to my topics for about 6 months? There are so many people on the...

Well, i'm not going to say anymore, other than, thank you all for your time.

In that case I was trying to learn cursors, and there was no better way. I even prefaced and said something like, I don't want to be talked out...