 | |
Delete query
microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Delete query -
10-10-2003
, 11:46 AM
#2
| |||
| |||
|
|
Hi, I'm new on DTS and i need help. I'm trying to make a Data Driven Query Task whit a store procedure to delete rows from a table. I set the Query type as Delete and the store that i want to use but when i open de DDQT later the Query type appear as Insert. What i'm doing wrong? Thaks, Joaquín |
#3
| |||
| |||
|
|
You have to call the correct Query. i.e. http://msdn.microsoft.com/library/de...mtsk1_9w2z.asp -- -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global community for SQL Server professionals - http://www.sqlpass.org "Joaquín" <jarambarri (AT) elpais (DOT) com.uy> wrote in message news:egEke30jDHA.2060 (AT) tk2msftngp13 (DOT) phx.gbl... Hi, I'm new on DTS and i need help. I'm trying to make a Data Driven Query Task whit a store procedure to delete rows from a table. I set the Query type as Delete and the store that i want to use but when i open de DDQT later the Query type appear as Insert. What i'm doing wrong? Thaks, Joaquín |
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.