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 |
|
jerry8989
Starting Member
6 Posts |
 Posted - 2004-08-16 : 11:30:43
|
| I would like to know if there is any way possible to version a .DTS file? I know syspackage table contains the GUID Version of the DTS package but I need a version in a normal format like xx.xx.xxxx.I want to be able to take me .DTS file to a client site and be able to make sure that the .DTS file is the right version. Thank YouJerry |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-16 : 12:10:33
|
| You would need to come up with a version format for your files.Tara |
 |
|
|
jerry8989
Starting Member
6 Posts |
Posted - 2004-08-16 : 12:25:40
|
| What do you mean?I want the version to be in this format: ##.##.####How can I have the .DTS file hold this version? |
|
|
|
jerry8989
Starting Member
6 Posts |
Posted - 2004-08-17 : 13:30:22
|
| Anyone please help!!!!! |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-08-17 : 13:32:15
|
| Why don't you just version it on your own? Or via source control? Otherwise, you are probably going to need to write custom VBScript to do it.Tara |
|
|
|
MuadDBA
628 Posts |
Posted - 2004-08-18 : 15:50:44
|
| The simplest way would be to put a text label in your DTS package, with the version # in it. Update that anytime you change the package. Open it using SQL Server to verify the version number.Combine this with some form of version control software, and you should be all set. |
|
|
|
|
|
|
Versioning DTS files