?
Solved

RE : SSIS

Posted on 2011-03-20
11
Medium Priority
?
416 Views
Last Modified: 2013-11-10
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
Comment
Question by:rajneesh1978
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 35178198
>> 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
 
LVL 39

Assisted Solution

by:Pratima Pharande
Pratima Pharande earned 1000 total points
ID: 35178243
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
 

Author Comment

by:rajneesh1978
ID: 35178396
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
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 
LVL 57

Assisted Solution

by:Raja Jegan R
Raja Jegan R earned 1000 total points
ID: 35178398
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
 
LVL 39

Accepted Solution

by:
Pratima Pharande earned 1000 total points
ID: 35178414
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
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 35178420
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
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 35179086
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
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 35383861
I would recommend split between

http:#a35178198 , http:#a35178243 , http:#a35178398 and http:#a35178414
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 35458527
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!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Ready to get certified? Check out some courses that help you prepare for third-party exams.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question