SQL Server Performance Forum – Threads Archive

Data loads with DTS packages

Hi, I am researching on the possibility of creating and using a configuration file to be used to set up global variables setting up environmental values and other initialization variables needed to configure in data loading a DTS package. The intension is to automate the manual configuration using a simple configuration file so that the DTS package can be pointed to use the configuration file to initialize needed variables depending on the environment to be data loaded. Thus same configuration file can be used in data loading to different tracks/ environments without being having to manually set the global variables. I would very much appreciate and directions, advise or resource information which can be given on this. Thanks!

---

You can go thruhttp://www.sqldts.com in this case for all sorts of issues with dTS and what you want to accomplish. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

Thanks Satya! for your information.

---

Satya, I have to give you a huge "thank you" it’s a great site you told me about.
so THANKS!!!!

---

Yes it is, as I do follow all the time when I have anything to do in DTS. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.

---

]]>