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 |
|
inbs
Aged Yak Warrior
860 Posts |
 Posted - 2009-07-02 : 02:07:49
|
| hi,how can i see the current version of package in MSDB (after deploy).is their way in SQL to see it? |
|
|
waterduck
Aged Yak Warrior
982 Posts |
Posted - 2009-07-02 : 02:42:33
|
| select @@versionps. not sure correct or notAMITOFO+AMEN+YA ALLAH Hope the query works |
 |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-07-02 : 03:11:37
|
| there is not easy way,why it is so complicated? |
|
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2009-07-02 : 07:09:12
|
I don't know.Some guys would say it is not the job of SSIS to make versioning because it is to consider by the developer or you have to use source save or so.Sometimes (but only sometimes) I think in the IT-World we are going back to the roots...I am waiting for the day Word is no more asking "save document before quit?" like in first versions... because saving a document is to consider by the user.Fred
No, you're never too old to Yak'n'Roll if you're too young to die. |
|
|
|
inbs
Aged Yak Warrior
860 Posts |
Posted - 2009-07-05 : 03:35:15
|
| Fred thanks to your answer,i cant work like the link you send to me.it is must to be easier way to know what is last version of packae in MSDB |
|
|
|
|
|
|
version of package