Friday, July 15, 2011

Learning Integration Services

Follow this tutorial:

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