October 14, 2011 at 4:14 pm
I have started a new engagement where there are SSIS packages across three different servers: DevServer, TestServer, and ProdServer. I need to find out if the SSIS packages in Prod are the same version as in Test and Dev and so on. Currently, I am running a query across each server to get the PackageName, verbuild, and createdate from msdb. Is there a way to do this dynamically, so we will be able to automate the coordination? We have several Dev, Test, and Prod servers I'm going to have to maintain.
October 17, 2011 at 1:25 pm
No source control? At this point I would simply say that evrything in Prod is correct and the most recent (that is what you are using so it must have been developed and tested in QA). That would be my starting point. I would get all reverse engineered back into BIDS and saved in some sort of source control program.
October 18, 2011 at 10:44 am
gary.mazzone (10/17/2011)
No source control? At this point I would simply say that evrything in Prod is correct and the most recent (that is what you are using so it must have been developed and tested in QA). That would be my starting point. I would get all reverse engineered back into BIDS and saved in some sort of source control program.
+1 to this.
If you really need to look at it through the query I'd look into doing something with PowerShell to query across environments.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply