SQLocity (3/10/2011)
Thanks Koen, that is pretty much the same conclusion that I came to.
Yeah, I can be a bit redundant sometimes 😀
SQLocity (3/10/2011)
The next thing I need to figure out is what is the difference between copying a .dtsx file to a file system location vs. saving a copy of the package to a file system location.
There is a difference? Maybe you can compare the xml files to see if there is an actual difference.
SQLocity (3/10/2011)
For some reason, when we copy a dtsx file to a certain location, it doesnt always pick up the correct config. We have to open the package up to verify that it is using the correct configs.
What sorts of configurations are you using?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP