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.

 All Forums
 General SQL Server Forums
 New to SQL Server Administration
 Dtsx pacakge 2005 or 2008 identify

Author  Topic 

sunsanvin
Master Smack Fu Yak Hacker

1274 Posts

Posted - 2011-08-11 : 10:17:53
Hi Team,
I've a Dtsx package, (this is using by sap application) i'd like to know wether it is sql server 2005 package or 2008 package. can you guide me how can i identify that?

thanks in advance

Arnav
Even you learn 1%, Learn it with 100% confidence.

gwilson67
Starting Member

42 Posts

Posted - 2011-08-29 : 00:46:13
Run the following query:

select * from dbo. sysssispackages

There are 2 columns: VerBuild and package format that should you get your answer.



Greg
http://www.freewebstore.org/tsqlcoderepository
Powerful tool for SQL Server development
Go to Top of Page
   

- Advertisement -