• Phil Parkin (7/17/2014)


    podmate (7/17/2014)


    --

    Now that I am building ETL apps in SSIS, I long for the days when I could script out my ETL process and did not have to deal with the limitations of a wysiwyg app.

    --

    Have you investigated BIML?

    I just read through the BIML Stairway ( http://www.sqlservercentral.com/stairway/100550/ ).

    The author did a great job of introducing BIML and showing how it can be a useful tool.

    I played with BIML a bit last night and it feels a lot like a band-aid.

    Combining a wysiwyg tool with XML with SQL scripts/code with n level graphical dropdown lists just seems like MS trying to force their graphical only tool set mantra into a script based world. Not an optimal solution.

    Although I am not very impressed with the implementation or user friendliness of BIML, it certainly seems to be a much more intelligent way for one to write complicated SSIS type packages as opposed to using only SSIS.

    Thanks for pointing it out.

    I am going to try and find a project at work that I can use BIML on.