February 4, 2011 at 3:25 am
1. How to find the installed version of Hotfix?
2. Is there a way to find the Server name in the job/dts i.e., A Test environment DTS/SSIS would be pointing to Prod DB. How to identify such jobs/DTS?
February 4, 2011 at 4:45 am
1. See if SELECT SERVERPROPERTY('productversion') or SELECT @@version work for you.
2. What do mean with this question? Do you want to know on which server the job is running? Or on which server the SSIS package is running?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2011 at 5:35 am
1. 9.00.3077.00 .. i got this from the server.. so 3077 is the hotfix?
2. I want the server against which the dts/job runs..say,
Server-1 -- Prod
Server-2 -- Test
I have an DTS in Server-2, which points to Server-1 and extracts data from Prod. Is there any way to determine such DTS which runs against Prod (but from Test)?
Thanx for the reply
February 4, 2011 at 5:40 am
Here's a list that describes the version numbers:
http://www.sqlteam.com/article/sql-server-versions
And an BOL page from MS with more info:
http://support.microsoft.com/kb/321185
Regarding DTS, I can't really help you as I have no experience with the tool.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2011 at 6:30 am
Thanks for the link.
As for DTS, so you are one of those lucky guys who started with SSIS?
February 4, 2011 at 7:09 am
balasach82 (2/4/2011)
As for DTS, so you are one of those lucky guys who started with SSIS?
Damn right I am 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 4, 2011 at 9:47 am
balasach82 (2/4/2011)
2. Is there a way to find the Server name in the job/dts i.e., A Test environment DTS/SSIS would be pointing to Prod DB. How to identify such jobs/DTS?
The only way to tell what the data source is would be to look at the connections in the package itself. It sounds like you have a particular package in mind. Open it in DTS designer and look at the source connection.
Greg
February 6, 2011 at 10:48 pm
Actually, i have inherited a test server which has about 100+ dts. some of them have not yet been used and maybe still pointing to prod. Hence, I need to find those dts's and delete them/point them to test.
February 9, 2011 at 2:42 pm
Did you try searching those 100+ .dtsx files using a text editor like Textpad? (We can open .dtsx files as a text file).
February 14, 2011 at 3:13 am
My assumption is we can open .dtsx files (2005/2008) in text editor. Can we also open .dts (2000) files in text editor?
February 14, 2011 at 11:15 am
Yeah, that's true! My bad!
Anyways could you try saving those DTS packages as Visual Basic Files? They can all be opened in VB IDEs or even text editors.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply