Using the lookups took 31 min 15 seconds. Using the joins on the server took 45 minutes.

The table I split into 3 pipelines contained 31,413,234 records. I did restrict to...

I tried it both ways, one with doing the joins on the server in the query and another where I used lookups to pull only the columns needed in the...

No my ColA values could be different with more or less distinct values with each execution.

I searched and searced the web and finally found the answer. There is only one enumerator for the recordset so if you need to use it with more than one...

Thanks TheSQLGuru, I have one question though. I'm assuming that the script needs to executed on the master database and then the sprocs created are called inside jobs, other sprocs...

Thanks, worked like a charm. However I need to move the mdb files again. Is there any way to save the the logins with their database permission settings intact when...

oops, didn't see the posts on the second page and had double posted the preceding post.

SUCCESS!!!

Turns out you can change the DelayValidation for the package and it is scoped down to everything in the package.

Also needed to make sure every task, container, or...

I have Sequence container which holds a DataFlow which holds a number of sources which I want to turn off Validation. If I set the DelayValidation Property of the Sequence...

I have a different error now: "VS_NEEDSNEWMETADATA" which is resulting from the datacolumn being changed on the database I'm pulling from but with the following properties set it causes the...

Is there a possibility that the SendEmailTask sent the email then failed afterwards? I recieved an email stating that one of the sequence containers failed (The Email task is connected...

Is it possible that the "ErrorCount" value being checked is the error count for the entire package and not just for that task? I had a SendEmail task with its...

I have the MaximumErrorCount = 10.

Good to know. Thanks guys.

I never found an easy fix for this but managed to find a work around. I changed my datasource task to use a "Select" statement and added the ISNull(Fildname,'') in...