Chapter 18. Deploying and Managing Solutions in Microsoft SQL Server 2008 Integration Services
After you finish developing your packages, you have to move them to the production server, where they are typically executed on a scheduled basis using SQL Server Agent Job Steps or by direct invocation through the DTExec tool. In any case, you have to make sure that your packages will be executed correctly, taking into consideration that the production server might have different resources than your development environment (for example, different drive letters) and also that the security context under which packages will be executed might be completely different from the one that you used in development. In this chapter, we present best practices for ...
Get Smart Business Intelligence Solutions with Microsoft® SQL Server® 2008 now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
