Currently I read in a file and then take each line from the file and run an INSERT statement. A bulk insert would be much faster however getting all the SQL servers to give the appropriate permissions would be too difficult right now.
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 …