Solved

How to deploy SSIS Packages

Posted on 2011-03-08
4
525 Views
Last Modified: 2012-08-13
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
Comment
Question by:AXISHK
[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
4 Comments
 
LVL 13

Accepted Solution

by:
agarwalrahul earned 300 total points
ID: 35067220
0
 
LVL 1

Assisted Solution

by:lalitgada
lalitgada earned 100 total points
ID: 35067224
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
 
LVL 6

Assisted Solution

by:jonaska
jonaska earned 100 total points
ID: 35068414
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
 

Author Closing Comment

by:AXISHK
ID: 35102637
Tks
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Naughty Me. While I was changing the database name from DB1 to DB_PROD1 (yep it's not real database name ^v^), I changed the database name and notified my application fellows that I did it. They turn on the application, and everything is working. A …
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…
In this video you will find out how to export Office 365 mailboxes using the built in eDiscovery tool. Bear in mind that although this method might be useful in some cases, using PST files as Office 365 backup is troublesome in a long run (more on t…

623 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