Search This Blog

Wednesday, August 29, 2012

Import a package by Using SQL Server Management Studio

  1. Click Start, point to Microsoft SQL Server, and then click SQL Server Management Studio.
  2. In the Connect to Server dialog box set the following options:
    • In the Server type box, select Integration Services.
    • In the Server name box, provide a server name or click <Browse for more…> and locate the server to use.
  3. If Object Explorer is not open, on the View menu, click Object Explorer.
  4. In Object Explorer, expand the Stored Packages folder.
  5. Expand the subfolders to locate the folder into which you want to import a package.
  6. Right-click the folder, click Import Package. and then do one of the following:
    • To import from an instance of SQL Server, select the SQL Server option, and then specify the server and select the authentication mode. If you select SQL Server Authentication, provide a user name and a password.
      Click the browse button (…), select the package to import, and then click OK.
    • To import from the file system, select the File system option.
      Click the browse button (…), select the package to import, and then click Open.
    • To import from the SSIS Package Store, select the SSIS Package Store option and specify the server.
      Click the browse button (…), select the package to import, and then click OK.
  7. Optionally, update the package name.
  8. To update the protection level of the package, click the browse button (…) and choose a different protection level by using the Package Protection Level dialog box. If the Encrypt sensitive data with password or the Encrypt all data with password option is selected, type and confirm a password.
  9. Click OK to complete the import.

 Source: http://msdn.microsoft.com/en-us/library/ms141235%28v=sql.105%29.aspx

No comments:

Post a Comment