After you’ve completed your SSIS package, you can easily deploy and install it with SSIS wizards. You can also schedule SQL Server Agent jobs to execute SSIS packages. And if you have SQL Server 2000 packages, you may be able to use the Data Transformation Services Migration Wizard to map their tasks to the equivalent tasks in SSIS.
The SSIS Package Deployment Utility
BIDS creates a package deployment utility that you can use to deploy your packages to any computer. After building the package deployment utility, you can use the DTSInstall.EXE executable (created in the folder of your deployed project) to install packages using the SSIS Package Installer Wizard, which guides you through the process of installing files on either the file system or SQL Server.
The following steps will create a simple deployment utility for a completed SSIS package:
Migrating SQL Server 2000 DTS Packages
SQL Server 2000 packages can be migrated by using the Data Transformation Services Migration Wizard. The wizard maps tasks within the SQL Server 2000 package to their equivalent DTS tasks in SSIS. For those tasks that do not map to SSIS, the new package structure will encapsulate non-SSIScompliant functionality within an Execute DTS 2000 task.
To launch the Migration Wizard, in BIDS, within an SSIS project, right-click the SSIS packages folder in the Solution Explorer window and select Migrate DTS 2000 Package. The wizard will step you through the migration process.
It is also possible to run DTS packages within the SQL Server 2008 environment as legacy components.
This ensures that the conversion process of a large number of DTS packages does not disrupt any plans to migrate to SQL Server 2008. There is also a DTS package editor, contained in the SQL Server Feature Pack available from Microsoft.com, which you can use to edit legacy DTS packages.
Scheduling an SSIS Package
SSIS packages can be scheduled using SQL Server Agent jobs in SQL Server Management Studio. Jobs can be scheduled to execute SSIS packages stored in SQL Server, on the file system, or in the SSIS store.
This exercise shows you how to schedule an SSIS package that is stored within SQL Server (in the msdb database).
SQL Server 2008 Related Interview Questions
|SQL Server 2000 Interview Questions||MSBI Interview Questions|
|SQL Server 2008 Interview Questions||SQL Server 2005 Interview Questions|
|SSIS(SQL Server Integration Services) Interview Questions||SSRS(SQL Server Reporting Services) Interview Questions|
|Microsoft Entity Framework Interview Questions||LINQ Interview Questions|
|SQL Server Analysis Services (SSAS) Interview Questions||Sql Server Dba Interview Questions|
SQL Server 2008 Related Practice Tests
|SQL Server 2000 Practice Tests||MSBI Practice Tests|
|SQL Server 2008 Practice Tests||SQL Server 2005 Practice Tests|
|SSIS(SQL Server Integration Services) Practice Tests||SSRS(SQL Server Reporting Services) Practice Tests|
|Microsoft Entity Framework Practice Tests||LINQ Practice Tests|
Sql Server 2008 Tutorial
Sql Server 2008 Overview
Sql Server Installation And Configuration
Sql Server Encryption
Automation And Monitoring
Integrated Full-text Search
New Datatypes In Sql Server 2008
T-sql Enhancements For Developers
T-sql Enhancements For Dbas
Sql Server And Xml
Sql Server Xml And Xquery Support
Linq To Sql
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.