I've come up with a possible work around. If you have permission to run Exe SQL Task to update the schema on the source to the dbo schema which more...

OK, thanks I will try it that way. I have another question. I was trying tp update my task to only copy one table over but when I tried to...

Hmm, more than likely not. How do I find out? Im thinking thats not something I can add through TSQL?

I was told someone interviewing me would ask this. In my 7 years of DB Development Ive never had a need like this but thought I could vaguely remember some...

Is there a way to do it in the declaration?

I figured it out, I forgot to add the Order By clause. Apparently having the the settings in the oledb src isnt enough to get it sorted you have to...

won't that still return both records?

I found the following on forcing thepkg to run in 32 bit mode:

Source: http://sqlserverpedia.com/blog/sql-server-bloggers/quick-reference-ssis-in-32-and-64-bits/

Choosing Bitness Inside Business Intelligence Development Studio (BIDS)

If you're running your package inside BIDS, the...

Thanks Elliot, is there a setting to force it to run in 32 bit?

Ok, I have another issue so please disregard the previous post.

The issue I have now is that I have an OLE DB source using a connection mgr that is...

Thanks, the cross apply did the trick!

I'm not sure what they are doing yet. I just need to learn how to do this.

Would there be any tables in MSDB that may have a record of the job exe?

Unfortunately the job was run sometime last night between 5pm and 9pm and our backup is scheduled nightly at midnight so I wouldn't think the lastnights backup would have the...

I figured it out. I went into the Expressions for the Exe SQL task and set the SQLStatementSource to the following:

"Exec uspDatafileExists " + @PrefixVariableName + "inscode_t"