Jeff thank you! That was quite a lot of useful information. Yes I went with the LEFT JOIN/NULL then I tried the EXCEPT on the keys and that was just...

Yes I believe OPENQUERY in this case is limited to the capabilities of the connection to the AS400 (which is hosted off-site from the sql server and we have a...

I never stated that the MERGE would be fast and it is not because you are using an OPENQUERY. I avoid it because it is terribly slow and I could...

Robert, the source table is in the lookup transform itself. So I do not know of a way to feed that and change the data types. I have tried doing...

Well it is looking like the SSIS method is not going to work either sigh 😉

Apparently there is a bug when using a Lookup transform on DB2 data when it...

Ok so finally getting the testing done on this.

So far I am finding OPENQUERY to be a slower method. Are there particular things I should be utilizing in order...

Jeff thank you that makes sense. I will test this here shortly (or possibly tomorrow as I am getting sleepy!) and run some tests on the OPENQUERY. If run into...

Also one further quick question; since I do have 75+ tables I am loading on a nightly basis...would I just create multiple jobs to handle this load instead of multiple...

Thank you for your response Jeff.

I do apologize for my post before, I have been under quite a lot of stress and am severely sleep deprived.

Also, in 9...

Jeff Moden (12/7/2012)

---

I guess my question would be, why do you need to use SSIS for this task? Why not just grab the data using OPENQUERY from a linked...

Robert,

Thank you for the response however, I am looking for the actual method involved in SSIS, not whether it is possible or not.

I am aware of how to...

Hi Robert thank you for your response!

To answer your questions; Yes there are Modified dates and Created dates (In our system they are called Change Date and Entry Date,...

I am assuming your company has a front facing web or application server that any external URLs would be hosted on? If so you could have your network admin set...

I don't think it is rude if you ask up front if you are diplomatic about it. If you just say "Hey what are you going to pay me?" That...

So just to throw my hat into the discussion regarding integer vs date iso standardized formats;

I just used the YYYYMM format as that is the default for financial 'period'...