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
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
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
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).SSISDepl
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.
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).SSISDepl
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.
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
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
I would recommend split between
http:#a35178198 , http:#a35178243 , http:#a35178398 and http:#a35178414
http:#a35178198 , http:#a35178243 , http:#a35178398 and http:#a35178414
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
ASKER