Solved

How to deploy SSIS Packages

Posted on 2011-03-08
4
515 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
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

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

757 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now