Go Premium for a chance to win a PS4. Enter to Win

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

How to deploy SSIS Packages

I have created a SSIS Packages, under c:\mytest\elt\ssis.dtsx.

It works fine under SQL 2008 environment. Just wonder how to schedule it under Window 2008 to run it daily ? And how to setup the variables in the package before execution ?

Thanks
0
AXISHK
Asked:
AXISHK
3 Solutions
 
lalitgadaCommented:
just right click on solution name ther will deploy option will be appear.

there is problem in scheduling to sql server agent but alternatively you can schedule it through windows shedular calling it through batch file.
0
 
jonaskaCommented:
Easyest way is to schedule from SQL Agent.
Create a new job and a new step. There will be an option for SSIS package.
There you can point out a package from the file system and also configure various settings (connectionStrings for example) for the package.

The most common problem with scheduling from SQL Agent is that some oleDb drivers (mainly office related) are not working from x64 and need to be scheduled with the x86 version of dtexec.
0
 
AXISHKAuthor Commented:
Tks
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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