I have a SQL routine that has been written by someone else. I want to copy the SQL file into an existing DB as a Store Procedure to run. It will create a list of new tables and reports to be used in the DB.
SQL Server Integration Services can read XML files, that’s known by every BI developer. (If you didn’t, don’t worry, I’m aiming this article at newcomers as well.)
But how far can you go? When does the XML Source component become …