That's a nice little trick, Frank. Thanks for the suggestion.

Unfortunately, it doesn't quite work for my setup. Apparently when you put an SSRS project in a solution with an...

Shaun,

I think you might be missing the point slightly.

I don't need parens around the first part of the statement because that statement will always be true and I want it...

The code is correct, however, I think (and I haven't had a chance to test it yet because I'm solving other problems) the issue is the difference between the datatype...

I'm not sure a function is needed for an insert. The left outer join suggestion is a good one, though.

Usually what I do is...

Insert into MyTable (col1, col2, col3)

(Select...

Thanks for the info, jjarupan. I'll take a look at it. @=)

FYI: Todd's solution worked for getting rid of the #13119 error message on the toolbox.

Of course, it took a while for VS to reinitialize the toolbox after I...

Oh, the reason I needed the bucket names.....

I can now do a JOIN between the Staging table and the DimCoverageBucket table on the BucketName so that I get...

As soon as my current code run quits, I'll try that, buuuttt.....

Are you saying the parens around the OR part of the statement aren't working correctly? I put in...

I didn't look at my code before I submitted the post. The forum screwed it up. Let me try again.

ISNULL(RetroDate) == FALSE && (RetroDate lessthan (DT_DATE)"01-01-1900"...

Will do.

Also, just a note. My build problem doesn't seem to exist in other solutions, not even the one I created from scratch and moved my "problem child" existing...

And if there wasn't already a result set partially loaded, I'd agree with that.

You know how when you do a SELECT the results start loading as soon as...

Jim,

I appreciate your opinion, but I hate doing the half-day to full-day's worth of work uninstalling two programs and re-installing them if there is another perfectly logical explanation for the...

I was able to re-run my query without any problems. In fact, I haven't even closed out that session of SSMS yet. And haven't seen any additional error...

Other people are using BIDS with no problem on their PCs. I don't have time for a reinstall. My project is due Monday.

I finally closed the project out,...

DOH! I was looking at the wrong transformation task.

Thanks! That helps. @=)