SQL Server Performance Forum – Threads Archive
DTS on demand?
Is it possible to run DTS on demand by having a user click on a button in an application?I am creating a project in vb.net where I want the user to be able to hit an "update" button and data will be updated to my SQL Server table by DTS. Also is it possible to check for duplicate entries before running DTS? E.g I want to append to my table but exclude duplicate entries UNLESS the data has changed for that entry.
http://itmanagement.earthweb.com/datbus/article.php/619821 for relevant information. HTH Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS†with no rights for the sake of knowledge sharing.
quote: Is it possible to run DTS on demand by having a user click on a button in an application?
I am creating a project in vb.net where I want the user to be able to hit an "update" button and data will be updated to my SQL Server table by DTS.
I don’t know about vb.net but it is possible to execute package from vb6, you have to include specific library (I can’t rembember name now). Also you can run dtsRun utility from your app.
I am creating a project in vb.net where I want the user to be able to hit an "update" button and data will be updated to my SQL Server table by DTS.
quote:Also is it possible to check for duplicate entries before running DTS? E.g I want to append to my table but exclude duplicate entries UNLESS the data has changed for that entry.
You can use dts to exclude duplicates. You can load data into auxiliary table and then use Execute SQL task to implement logic you mentioned.
Hope it helps.
]]>