"Interface" for DTSing tables

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...
LVL 8
CamilliaAsked:
Who is Participating?
 
Anthony PerkinsCommented:
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
 
CamilliaAuthor Commented:
if I dont do DTS, what should I do??
0
 
CamilliaAuthor Commented:
>>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
 
Anthony PerkinsCommented:
Yes, that would certainly be simpler than calling a DTS package.
0
 
CamilliaAuthor Commented:
i will read that link and try the simpler method as well. thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.