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

Documentation in SSIS Expand / Collapse
Author
Message
Posted Monday, March 4, 2013 9:00 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:06 AM
Points: 321, Visits: 569
I am just starting learn and use SSIS, and was wondering how you document changes? In a stored proc I always created a comment block at the start and at the end of the code change, and commenting out the code that was being replaced. I also placed a version number that matched the comments at the top of the stored proc.

I do not have any version control software, and was wondering how others handle documenting changes in your SSIS package.
Post #1426298
Posted Monday, March 4, 2013 11:47 AM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 490, Visits: 1,865
I add an annotation block to the package and keep high level revision history there. The packages are source controlled but the annotation block gives me a quick record to review.

I've also found that making extensive use of the description field for each object is quite helpful for overall documentation and understanding.
Post #1426384
Posted Thursday, March 7, 2013 10:57 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Wednesday, July 30, 2014 10:34 AM
Points: 386, Visits: 624
Tortiose subversion and Mercurial Hg are both free Source code control packages. Of the two, I think Mercurial is probably better for managing SSIS because of the number of files generated automatically (Solution and Project folder, .sln, .dtproj, .dtsx, dtscongif, databases, manifest files etc)

One of the challenges with SSIS (and SSRS for that matter) is that becasue the whole thing is XML based, and includes the diagram layouts in the XML, you can change the dtsx just by moving a constraint arrow or a task without actually changing the logic or performance of the package so how do you distinguish between a change in presentation and a change in logic. I'm still to resolve this one so if anyone can help...




Post #1428146
Posted Monday, March 11, 2013 12:13 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:06 AM
Points: 321, Visits: 569
Thanks, I will download those and give them a test drive. Yep, I agree... tracking xml changes means that simple changes get flagged as a new version. But you then still have the issue of commenting on the changes. In code you just place starting and ending version marks, and comment out the old code. That is not possible in a SSIS package.
Post #1429429
Posted Thursday, March 14, 2013 1:52 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 4:51 PM
Points: 7,097, Visits: 12,597
BIDS Helper has a Smart Diff feature that will ignore some changes in the XML, and hopefully only leave the real changes highlighted. Not that we can always make sense of what that XML is saying but it filters out a lot of the noise making it a bit easier. It's a free download and plugs into BIDS. Smart Diff is just one of the useful things about it. I highly recommend it.

__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato
Post #1430801
Posted Thursday, March 14, 2013 9:14 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, August 14, 2014 7:06 AM
Points: 321, Visits: 569
Thanks.. our web development team uses VSS, so maybe I can get connected long enough to do the install.
Post #1431050
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse