SOLVED!  I was using Row_Number in one of the fields.  The way it was sorted wasn't fully defined so SQL was sometimes numbering it one way and sometimes another way.

The project contains a bunch of packages that load tables, but it's pretty straightforward.  There are OLE DB Sources and OLE DB Destinations.  No lookups, no transformations.  The OLE DB Sources...

Yes, Jason, your understanding was correct. 

I found a WHERE IN being used in the stored procedure that I changed to an INNER JOIN which made it much more...

No, when I remove the two columns altogether from everywhere, the query hangs upon trying to insert the records into the table.  If I put the two columns back in, it...

Hi Steve,

I tried it and it didn't work, but then figured out it has to do with my stored procedure, not SSIS.  I am using a stored proc to insert records into...

Nevermind. I finally figured out it only displays it that way in preview mode. It's fine if you export or deploy it. Thanks anyway!