Started pencilling it out and noticed some things but nothing super serious....

I noticed that the second table I was joining (EXTENDED) was LEFT OUTERed when it really should be INNERed...

hehehe...

true blue genius that I am, forgot to attach the new file

yeah....that's how I roll!

Current attachment has....

goodGrief - original

goodGrief_halflast - last join is only joined on the first column (STATE_ID)

goodGrief_1less - last join is totally removed

I'll work on pencilling out the design and see...

Is this going to be a scheduled type job where you are always going to be loading the same Excel sheet or is this something like you want to be...

Also....COMPANY_NAMES has 3 rows....

FFG_STATES has about 52......

which is why I don't understand why it's complaining about those 2 particular joins.

If any join should be throwing fits it seems like it...

I had also considered that but the weird thing in my mind is that when I modify that join to only use 1 of the columns, the total output switches...

Here's the Exec Plan in XML form as requested.

I have also taken all references to the other view from the query and it still dies on that last join.

SELECT *

FROM...

Made a few more advances in my troubleshooting....

The Zip Code table that it is joining to is actually a View which includes a State table.

That state table is joined, itself,...

I tried that.....not sure if it will work once compiled and scheduled but definitely was not working within the Designer.

What I ended up doing was I replaced my FTP ReceiveFiles...

Kudos! That's all it was.

Just needed to reinstall MS SQL 2005 and it works fine now.

The variable already exists.

When I right click on the package and click Variables, I see strFileName.

But, again......even if the variable didn't exist, I would expect that when I hit the...

I don't even get to the point where I'm supposed to map the variable to the parameter.

I hit the "Add" button to create a new parameter to the SQL Execute...

anybody have an answer to my question about the connection used to pull Package Configurations.

Have researched everything I can find about using SQL tables for the Configuration but they all...

ooo...nice trick...I like the sound of that.....

what do you use to compare them? Just a text editor....probably even something like Beyond Compare should work....unless there's some decryption in...

Oh, and there is a data conversion step between the source pull and the destination push. All it really does it turns the DB2 string output into a string...