Aha! I knew it... I just didn't have a SQL box nearby..

However, with all that said, I chose to never use it.. In my case I broke each...

Tables or files, I think that is largely style and environment.

My big thing is that if I were to compare the DTSX files I released from dev to the one...

I don't think using environment variables for most configs is a good idea. Perhaps one or two to point at the config server and database. My major opposition...

I use a script with DTUtil as well. My goals is to not change the package at all once it is released from Dev. I often use config...

You are very welcome. SSIS is a very good tool but its learning curve is pretty steep.

Good luck.

CEWII

Brian,

I wrote a couple articles last year on the same (or at least a close) subject..

http://www.sqlservercentral.com/Authors/Articles/Elliott__Whitlow_/483442/%5B/url%5D

CEWII

I think that there are some significant issues with your solution. I have to strongly recommend that you switch from trying to push the data through a linked server...

Good thought Tom. I made a bit of an assumtion about access.. I typically have SQL logged in with an account that can do nearly anything. It...

I'm curious how you are verifying insert order.. For a select statement in sql 2005+ (and perhaps earlier) you could not guarantee the order that rows were returned without...

Are you placing the config files at EXACTLY the same path as they existed in development? I have seen cases where it remembered the original values.. In the...

For a datawarehouse implementation we put each connection in its own xml file and ALL packages shared the same config file, so every connection to a particular database could be...

I admit I am really surprised. I could see it picking up values from config locations but if you changed a variable value within the package I just don't see...

When you load the file this way I don't see how you would ever get run-time values.. I don't think this can be done with a script. However...

In your environment is there a process to challenge a requirement? I have experienced many cases where the business makes a technical requirement without being able to justify or...

In your environment is there a process to challenge a requirement? I have experienced many cases where the business makes a technical requirement without being able to justify or...