Post reply

Compare & Merge SSIS ETL

  • June 15, 2009 at 8:28 am

    #95594

    Hi All,

    I have a code base in 2 repositories with different versions. Now i have to merge both the changes. My ETLs are implemented using SSIS.

    Any pointers for merging the SSIS ETLs will help me a lot

    Thanks in advance,

    Raju P. S

  • June 15, 2009 at 8:35 am

    #1009689

    Hi

    Try a "Slow Changing Dimension" task. Here is a thread which explains:

    SSIS Upsert or Update and Insert

    Flo

    The more I learn, the more I know what I do not know
    Blog: Things about Software Architecture, .NET development and T-SQL

    How to Post Data/Code to get the best Help How to Post Performance Problems

  • June 15, 2009 at 8:47 am

    #1009698

    Hi Flo,

    Thanks for the quick response. I am quite comfortable with SCD, but my issue is not merging / joining 2 tables.

    I have already implemented and working ETLs in my code base. During the course of time, same copy has been modified by 2 tracks of people, one for fixing the issues, another for some new enhancements.

    Now before releasing my final copy of these ETLs, i need to merge these 2 ETLs updates.

    So I am looking for some tool which will help me compare the changes between these 2 versions and merge them.

    Thanks in advance,

    Raju P. S

  • June 15, 2009 at 10:28 pm

    #1010013

    I don't beleive there is anything like this from Microsoft. You might want to search around to see if anyone has implemented this for themselves.

    [font="Times New Roman"]-- RBarryYoung[/font], [font="Times New Roman"] (302)375-0451[/font] blog: MovingSQL.com, Twitter: @RBarryYoung[font="Arial Black"]
    Proactive Performance Solutions, Inc.     [/font]    [font="Verdana"] "Performance is our middle name."[/font]

  • June 16, 2009 at 11:44 pm

    #1010645

    It would be very difficult to branch and merge SSIS packages. Even cosmetic changes like moving tasks on the control flow will cause the XML to change and that makes a diff really hard to interpret.

    I think you are going to have to manually reconcile the multiple versions of the packages using BIDS. You might be able to copy some tasks from one package to another, other items may have to be rebuilt by hand.

    There is a tool on codeplex called BIDS Helper that has a smart diff feature. It basically ignores all formatting items then pretty prints the remaining XML and diffs it. You can't merge code but at least it will help ID the changes in both versions of the package.

    http://www.codeplex.com/bidshelper

  • June 17, 2009 at 12:43 am

    #1010657

    Thanks for the responses.

    I have got some tool which will help me to compare the ETLs. I am still evaluating to see the feasibility of the same. below are the details incase any one interested

    http://www.apexsql.com/sql_tools_ssis_compare.asp

    Thanks,

    Raju P. S

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply