Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

how can i run a sql server DTS by clicking a button in my VB.NET application.

Posted on 2008-10-23
3
Medium Priority
?
207 Views
Last Modified: 2012-05-05
I have a DTS that moves dBase data to my SQL 2005 Database.  This needs to be executed on command through my VB.NET application.

How can I run the DTS automatically or by clicking a button in my VB.NET application.

Microsoft help says I should reference their COM DTS namespaces and create a Standard EXE project, but I dont know what a Standard EXE project is.  

Does anyone have a solution?  
0
Comment
Question by:logoncom
3 Comments
 
LVL 9

Accepted Solution

by:
Sander Stad earned 2000 total points
ID: 22786247
0
 
LVL 22

Expert Comment

by:PedroCGD
ID: 22786289
from your application you can call directly the SSIS Package or a SQL JOB that has inside a SSIS package.
See my blog there is post there about calling a ssis project from asp.net using VB.net code
Regards

www.pedrocgd.blogspot.com
0
 

Author Closing Comment

by:logoncom
ID: 31509212
The 2nd URL is what I used... got it to work with 6 lines of code !!

Thanks.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Question has a verified solution.

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

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.
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.
When cloud platforms entered the scene, users and companies jumped on board to take advantage of the many benefits, like the ability to work and connect with company information from various locations. What many didn't foresee was the increased risk…
Enter Foreign and Special Characters Enter characters you can't find on a keyboard using its ASCII code ... and learn how to make a handy reference for yourself using Excel ~ Use these codes in any Windows application! ... whether it is a Micr…

579 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