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.