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
Solved

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

Posted on 2008-10-23
3
198 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 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Write to a printer using vb.net 9 40
VB.NET 2008 Publish Error 2 34
SQL Error - Query 6 41
Loops and updating in SQL Query 9 54
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

837 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