At Santanna we seem to have some very simply SSIS packages for ETLing flat files consumed from utilities. We:
- have an Execute SQL Task reach out to a stored procedure which ultimately calls a complicated select statement against a database table with columns holding a one-to-one dump of the flat file's data points
- in the Properties pane in BIDS, the SqlStatementSource donotes something like EXEC sp_Whatever pointing out which stored procedure to call
- have a Script Task put the data from the select to MSSQL via VB with inline SQL statements
- right-clicking on the task and selecting "Edit..." brings up a dialog box
- from here click "Edit Script..." to see the actual script
Today Paul Herrera taunted me over Twitter with: "What's wrong with putting code in a place that you CANNOT write unit tests for? :P" when he saw me tweet of SSIS. Indeed SSIS is kinda ghetto.
No comments:
Post a Comment