dbTalk Databases Forums  

How to write a program to connect to database(insert,delete,update) in c# and I want to put it DTS

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss How to write a program to connect to database(insert,delete,update) in c# and I want to put it DTS in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Rama Krishna Byri
 
Posts: n/a

Default How to write a program to connect to database(insert,delete,update) in c# and I want to put it DTS - 07-19-2005 , 03:26 AM







I want to use a program that periodically update the database like
insert,update,delete.. using C#.
And I want to make a package and deploy it in DTS.
So DTS will work by scheduler time.
So any body let me know the solution


Thanks
Rama


*** Sent via Developersdex http://www.developersdex.com ***

Reply With Quote
  #2  
Old   
Allan Mitchell
 
Posts: n/a

Default Re: How to write a program to connect to database(insert,delete,update) in c# and I want to put it DTS - 07-19-2005 , 05:22 AM






If you want to use DTS then pretty much all I would have C# do is call
Execute().

From what to what will you be doing these things?

Have you thought about replication as depending on how in sync you need to
be may rule out DTS.

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Rama Krishna Byri" <ramkrishnab (AT) mail (DOT) com> wrote

Quote:
I want to use a program that periodically update the database like
insert,update,delete.. using C#.
And I want to make a package and deploy it in DTS.
So DTS will work by scheduler time.
So any body let me know the solution


Thanks
Rama


*** Sent via Developersdex http://www.developersdex.com ***



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.