[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

"Interface" for DTSing tables

Posted on 2009-02-08
5
Medium Priority
?
222 Views
Last Modified: 2012-05-06
I might have to post this in .Net section but trying here first.

I want to DTS 2 tables from one database to another. I can schedule a DTS package or even do it manually but, another department wants to test the app and use the DTS.

I dont want to schedule the package as I dont know when they'll be testing. I want to give them a windows app with ONE button to press and DTS the tables.

Anyway to do this? can I call a DTS package using a stored proc? if so, then I can just call the stored proc from code...
0
Comment
Question by:Camillia
  • 3
  • 2
5 Comments
 
LVL 75

Accepted Solution

by:
Anthony Perkins earned 2000 total points
ID: 23586577
You can certainly call a DTS package from .NET see here:
http://sqldev.net/dts/dotnetcookbook.htm

However for such a simple task, you do not need DTS to do this.
0
 
LVL 7

Author Comment

by:Camillia
ID: 23586614
if I dont do DTS, what should I do??
0
 
LVL 7

Author Comment

by:Camillia
ID: 23586626
>>However for such a simple task, you do not need DTS to do this.

just insert from one DB to another using inline code??
0
 
LVL 75

Expert Comment

by:Anthony Perkins
ID: 23586699
Yes, that would certainly be simpler than calling a DTS package.
0
 
LVL 7

Author Comment

by:Camillia
ID: 23586706
i will read that link and try the simpler method as well. thanks.
0

Featured Post

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

Question has a verified solution.

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

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
There are some very powerful Dynamic Management Views (DMV's) introduced with SQL 2005. The two in particular that we are going to discuss are sys.dm_db_index_usage_stats and sys.dm_db_index_operational_stats.   Recently, I was involved in a di…
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…
As many of you are aware about Scanpst.exe utility which is owned by Microsoft itself to repair inaccessible or damaged PST files, but the question is do you really think Scanpst.exe is capable to repair all sorts of PST related corruption issues?

834 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