bulk update automatic - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Transact-SQL (2005)

bulk update automatic

Author

Topic

krushnapanda
Starting Member

18 Posts

Posted - 2007-08-10 : 05:59:36

helo dear
i have a one table with 5 column (say table1)
columns are code,name,age,dob,class
i have a notepad file with 2 colums (notepad.txt)
column are code,class

now i insert record in notepad.txt
like this
code class
1 II
2 II
..............
then save it,
now how to update the column class in table1 in SQL SERVER 2005
using DTS

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-10 : 06:00:58

Well you would need v2000 to design the dts package - but why do you want an application.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

krushnapanda
Starting Member

18 Posts

Posted - 2007-08-10 : 06:58:02

HELO DEAR,
that becoz i have a currency master table , and the currency value will change every day any time , so for this i create a sp
but how can i exec the sp automaticalyy in every 1 hours
thanks

quote:
Originally posted by nr

Well you would need v2000 to design the dts package - but why do you want an application.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Thanks

nr
SQLTeam MVY

12543 Posts

Posted - 2007-08-10 : 07:47:31

So not dts.
Just use the agent to schedule a job to run the SP.

Have a look in managenment studio.

==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources