Friday, July 15, 2011

Learning Integration Services

Follow this tutorial:
http://msdn.microsoft.com/en-us/library/ms169917.aspx

Gotchas
1. If your server instance isn't the default then you'll need to update the ODBC connection in every lesson. It's set to by default, which points to the default (unnamed) instance of SQL
2. In lesson 3 where you create a package configuration, make sure to keep two variables, one for folderName and one for fileName. FolderName is pulled out of the XML config file, while the filename is gotten by traversing the folderName.

No comments:

Post a Comment

There was an error in this gadget