Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase 12345»»»

SSIS package version control Expand / Collapse
Author
Message
Posted Monday, March 3, 2008 8:35 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, July 10, 2014 8:41 AM
Points: 1,042, Visits: 2,714
Is anyone using any sort of version control tools for SSIS packages? If so, what are you using and how has it worked out for you?

Thanks,
Tim




Tim Mitchell, SQL Server MVP
Independent Business Intelligence Consultant
www.TimMitchell.net
@Tim_Mitchell

Post #463182
Posted Monday, March 3, 2008 8:57 AM


SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:00 AM
Points: 912, Visits: 208
I am working with Team Foundation Server to do the version controling with SSIS which seems to be a great tool.

It is intergrated with Visual Studio so that you have less troubules.







My Blog: http://dineshasanka.spaces.live.com/
Post #463210
Posted Wednesday, March 5, 2008 1:45 PM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, July 28, 2008 12:22 PM
Points: 87, Visits: 147
I'm using Visual Source Safe. It's not bad if you can set up the project structure correctly; I'm still trying to find the optimal structure. Do you put all 'files' associated with a package in one project and shared into a separate one, or do you put each 'file' type into its own folder?

Tim
Post #464726
Posted Thursday, March 6, 2008 9:38 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 22, 2013 9:01 AM
Points: 18, Visits: 90
We're using TortoiseSVN and it works like a charm. Searching for previous versions is great and the software is free.

Matt H.
Post #465290
Posted Thursday, April 17, 2008 3:03 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 12, 2012 4:33 PM
Points: 24, Visits: 105
Matt Horton (3/6/2008)
We're using TortoiseSVN and it works like a charm. Searching for previous versions is great and the software is free.

Matt H.

How does it integration with integration services? no pun intended ;)
Post #486802
Posted Thursday, April 17, 2008 3:32 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 22, 2013 9:01 AM
Points: 18, Visits: 90
It's basically file based, so you check in the solution that your working with and then commit changes to the dtsx files as they occur. It's worked well for us so far.

Matt H.
Post #486819
Posted Thursday, April 17, 2008 3:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, November 12, 2012 4:33 PM
Points: 24, Visits: 105
cool, thanks.

it would be super-great if microsoft would add a "date modified" to their summary report in integration services proper, or a right-click to show information about a package, such as when it was loaded into integration services... but that's just me wishing.
Post #486825
Posted Thursday, May 1, 2008 12:46 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,279, Visits: 2,203
Is there a way to see when the SSIS package is modified? or any version history available from system table/view?



Post #493848
Posted Thursday, May 1, 2008 12:52 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Monday, July 22, 2013 9:01 AM
Points: 18, Visits: 90
You can search for previous versions through SVN, but SQL server doesn't store previous versions as far as I am aware.
Post #493849
Posted Thursday, May 1, 2008 1:14 PM
Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Wednesday, January 8, 2014 2:49 PM
Points: 1,279, Visits: 2,203
Thank you Matt.

system table dbo.sysdtspackages90, Is createdate column for originally “created” date only? If any change/modify for SSIS package, does the column reflect the change respectively which means showing the modified date?
Post #493865
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse