Thanks for the info. I was not familiar with using configurations for packages when I started this package. So I had variables for the destination files but then changed them...

Are you saying to put the formula I put in the Expression on the connection manager, into the ConnectionString parameter of the configuration? I tried that and the results are...

Karin, I am not familiar with using config files with SSIS can you show me an example of what you are talking about or perhaps a website showing this?

GSquared,

Thank you very much for the information. Being so new to SSIS I was stuck in a SQL2000 frame of mind and was thinking that if...

By using a high and low authority accounts would be using two SQL logins, and would require changing all of the packages if it is decided that the password needs...

That link is great. Thank you again for all of your help in this matter.

Thank you very much that will help a lot. I just babble at VB.net and was wondering, do you know where all of the DTS. information is documented? I use...

CozyRoc, Thanks for the info.

Here is the code: (Part 1 of 2)

SELECT O3.INXFLD02, O3.UNITCD, O3.WRKTYPE, O3.STATCD, O3.QUEUECD, O3.SUSPFLAG, O3.INXFLD04,

O3.INXFLD03, O20.ENDDATTIM#, O20.ENDUSERID, O3.CRDATTIM# , O3.VIFLAG

...

Yesterday it ran in 10 seconds or less (once it ran for 23 seconds). Today it has gone to about 4:30. During all of the good and bad run times...

Aaron/Scott,

Thank you both for your answers and sorry it has taken me so long to get back to this. I was at level 3054, so I ran SP2 again and...