Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-03-11 : 07:16:00
|
| Kristian Skotte writes "Hi!First: This is by far the best SQL Server site i've come across!!! Thank you! (Great forums, Nice users etc.)I'am beginning to build my DTS's and they are growning in numbers, I try to use dynamic stuff a much a possible to limit my typing if someting changes. But still I can see them growning :-)I mostly develop Internet applications and there i'am used to having a development, test and production environment (sometimes even pre-production). Here we use environment variables and a whole lot of stuff to make the code portable between the stages.I'am happy reader of Professional SQl Server 2000 DTS - but this book only covers howto - specifics. What I need is a best practise of how to enable migration and movement of DTS packages between development, test and production.What tools to use (not howto), when to use dynamic stuff, when ActiveX is needed and so one. Basicly how to design your DTS's without having to change a thing when moving them around.Ofcause everthing could be done in ActiveX, but that isn't really the way to go since the DTS tools are there - or???This i a big topic so references to another book would be great :-)My system info: SQL Server 2000 Enterprise Edition SP3 Windows 2000 serverRegardsKristian :-)" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2003-03-11 : 08:38:18
|
| You can use global variables to hold things like server/database names, ip addresses, paths and set them in the load and use activex script at the start of the package.Or better not use dts unless it's necessary.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
DTS production environment