the easiest way to run ssis 2008 dtsx and move ssis package
If you are storing the packages in file system, then you just have to move the .dtsx file to the target location. Then you just need to run the package via dtexec.exe command, assuming yo have SSIS installed in the target machine. To take the execution of packages one step further, you can use SQL Server agent to run the package via job. btw, did you mean Business Intelligence Development Studtio when you say 'developer server'?Help Others! Don't forget to mark your thread as answered
December 21st, 2010 9:04pm

this is good tutorial about how to deploy SSIS package and run it as sql server job: http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/http://www.rad.pasfu.com
Free Windows Admin Tool Kit Click here and download it now
December 21st, 2010 10:00pm

This could be really newbie question, i want to move my ssis 2208 package to another server. I have build ssis packages that runs well in developer server, and how to run it as task(really basic instructions please)? What file should i move and store to my live server? Thanks?
December 21st, 2010 10:45pm

I store it in MSDB, are you sure just the dtsx file? it raises error. Thanks
Free Windows Admin Tool Kit Click here and download it now
December 27th, 2010 11:05am

I store it in MSDB, are you sure just the dtsx file? it raises error. Thanks yes just the .dtsx file. What is the error that you are getting? Is SSIS 2008 installed on the server you wish to move the package. If not you cannot do this. there is no backward compatibility. Tweet me..
December 27th, 2010 11:20am

Ok, remind me if i'm doing a mistake. I deploy my package and store it in MSDB. It works fine in development server. My question is should i redeploy the package, in my understanding i can deploy the package from Integration services deployment manifest file. I copied all the BIDS files to live server and also the database, the error is completely can not run. CMIIW. Thanks
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 2:12am

what is error message exactly? http://www.rad.pasfu.com
December 28th, 2010 2:22am

To use Deployment Manifest, you should follow these steps: 1- Create the manifest first (set the properties in BIDS, and build your project then); 2- Copy all the contents of the Deployment folder in the project's folder into new server; 3- Run the .SSISDeploymentManifest file on the destination server. You will be able to deploy your package either to file system or SQL Server then.
Free Windows Admin Tool Kit Click here and download it now
December 28th, 2010 6:15pm

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics