Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 423
  • Last Modified:

RE : SSIS

Hi,

I have a SSIS package can anybody let me know

1) How to schedule package
2) how to deploy the package on another server

Thanks
0
rajneesh1978
Asked:
rajneesh1978
4 Solutions
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
>> 1) How to schedule package

You can create a SQL Server Agent Job to schedule the SSIS package to run at specific times..

>> 2) how to deploy the package on another server

Export the package to file system as a dtsx file, copy the file to a new server and Import the SSIS package in the new system and configure it..
0
 
Pratima PharandeCommented:
To Deploye Pagae follow the steps

http://msdn.microsoft.com/en-us/library/ms140117.aspx
and
http://msdn.microsoft.com/en-us/library/ms141693.aspx

schedule pakage
1. You can shedule it from windows schedular
2.Open up SSMS. Go to SQL Server Agent\Jobs.
Create a new job and then create a step. Inside the step there's a dropdown
that says 'Type:' Choose 'SQL Server Integration Services Package'.
Then just choose the right package and pick a schedule.
0
 
rajneesh1978Author Commented:
Can i create some installation file for SSIS package so that i will run that set up wizard to install my package on another machine.
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Raja Jegan RSQL Server DBA & ArchitectCommented:
In that case, you need to create a Deployment utility to achieve it..
More info about that here:
http://msdn.microsoft.com/en-us/library/ms137952.aspx

I hope it is referenced in the link provided by pratima_mcs earlier..
0
 
Pratima PharandeCommented:
yes you can dothat

1.http://bidshelper.codeplex.com/wikipage?title=Deploy%20SSIS%20Packages
2.
To create a package deployment utility
In Business Intelligence Development Studio, open the solution that contains the Integration Services project for which you want to create a package deployment utility.

Right-click the project and click Properties.

In the <project name> Property Pages dialog box, click Deployment Utility.

To update package configurations when packages are deployed, set AllowConfigurationChanges to True.

Set CreateDeploymentUtility to True.

Optionally, update the location of the deployment utility by modifying the DeploymentOutputPath property.

Click OK.

In Solution Explorer, right-click the project, and then click Build.

View the build progress and build errors in the Output window.

after this in bin floder you have found the deployement pack , copy the folder to machin where you want to deploye , run the menefest file
0
 
Pratima PharandeCommented:
With the Solution Explorer open Right-Click on the project name and click Properties
This will open the Project Properties Pages  
Select the Deployment Utility from the page
Change the CreateDeploymentUtility property to True
After you’ve gone through these steps the next time you build your project it will create the file (YourProjectName).SSISDeploymentManifest.  This file is located in the same folder as your packages in the bin\Deployment folder.

If you run this file it will open the Package Installation Wizard that will allow you to deploy all your packages that were located in the project to a desired location.

0
 
Alpesh PatelAssistant ConsultantCommented:
Hi,

You can created deployment package directly at specified location at time of build

Go to SSIS project property and enable deployment utility, set output path.

On build of package you can get the setup.

Execute it and follow friendly steps
0
 
Raja Jegan RSQL Server DBA & ArchitectCommented:
I would recommend split between

http:#a35178198 , http:#a35178243 , http:#a35178398 and http:#a35178414
0
 
PedroCGDCommented:
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now