Solved

How to deploy SSIS Packages

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
MS SQL Delete Query 9 37
replicated - directional or bidirectional? 3 36
TSQL recursive CTE challenge... 8 29
query optimization 6 15
Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Copy Database Wizard 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.
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

821 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