December 1, 2009 at 9:28 am
One of the users have developed a SSIS package in his local machine and would like to move it to development server and then later to Production..
I was wondering how can the package be moved from local machine to one of the servers....
December 1, 2009 at 11:19 am
Assuming that SSIS has been installed and configured on the same sever as the SQL Instance (which is not my expertise), one way would be to run it in a SQL Job.
Create a SQL Job and add a Job Step of type SQL Server Integration Services Package.
We use File System as our Package Source and put a UNC path to the package.
Make sure that the SQL Service Agent account (or whatever account the job will run under) has access to that path and access to all the paths and locations used in the package.
... hope this helps a little
December 1, 2009 at 11:23 am
May I suggest you to visit the blogs section of my site (site address in the signature) and look for the article on Nov 3rd "Deploying SSIS Packages"
Post here any questions you may have.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
December 1, 2009 at 11:45 am
One more reference for good measure:
http://www.mssqltips.com/tip.asp?tip=1428
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply