SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Documentation in SSIS


Documentation in SSIS

Author
Message
dwilliscp
dwilliscp
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2237 Visits: 784
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.
kl25
kl25
Ten Centuries
Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)Ten Centuries (1.2K reputation)

Group: General Forum Members
Points: 1188 Visits: 1875
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.
aaron.reese
aaron.reese
SSCrazy
SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)SSCrazy (2.5K reputation)

Group: General Forum Members
Points: 2549 Visits: 907
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...
dwilliscp
dwilliscp
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2237 Visits: 784
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.
Orlando Colamatteo
Orlando Colamatteo
SSC-Forever
SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)SSC-Forever (41K reputation)

Group: General Forum Members
Points: 41940 Visits: 14413
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
dwilliscp
dwilliscp
SSCrazy
SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)SSCrazy (2.2K reputation)

Group: General Forum Members
Points: 2237 Visits: 784
Thanks.. our web development team uses VSS, so maybe I can get connected long enough to do the install.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search