You're welcome. Always glad to help.

Hey, don't Lab Rats get cheese when they thread the maze correctly?

Where's mine??? I want CHEDDAR!!!

@=)

Mark,

What we were willing to do was to tell you not to lie and how to improve your skills so you wouldn't have to lie. Yet you seemed to...

Lynn,

Good catch!

I know my manager has been known to Google prospects before doing the phone interview. In fact, he did it just a few weeks ago on the last...

It definitely makes me wonder about the "manager is a Nazi" comment if he lies to get into the job, then admits his first week he was hanging out and...

Whenever I see that problem, it's because people are trying to use SSIS to pull data into a 2000 destination from a 2005 source. Unfortunately, SQL 2000 doesn't recognize...

So far the only resolution I have found is to stick an Execute SQL Task right before my Data Flow, modify the Proc to stick the data in a real...

That's pretty much what I did the first time. Did it again and got the same error message. I'm wondering if it's a combination of the CTEs and...

I tried following your suggestion and got an immediate failure.

Error message is: Column "MyColumn" cannot be found at the datasource.

The OLE DB Source has ValidateExternalMetaData set to false. It...

Michael, thanks for the correction. For some reason I really thought it wouldn't allow FULL OUTER.

Paul, really? Everything I've read said that partial & no caching is much...

BTW, Pretty sure the issue is the temp table myself since I tried redoing the proc with only the Temp table and not the CTE. Got the same "blank...

So, once I get everything properly set up, saving the ValidateExternalMetaData to False will allow the package to run?

I hadn't tried using a Proc stub, so of course I wasn't...

I've actually changed my two sources to two different dataflows that end up in the same destination staging table.

Unfortunately, while both sources do have crossover records, both sources also have...

John,

Actually, there wasn't much processing going on after the Split. And over the weekend, I just discovered what you're referring to (even though I didn't read your post until this...

Michael,

The problem is that I'm working on "staging the data" right now. I've already got everything in two separate SQL DBs (mainframe uploaded to SQL and the SQL...