Re: DataDrivenQuery UPDATE without using scripting

#1

I doubt you will find a way to do it.

DTS must take every row you give it and issue an UPDATE Statement against
it. This can only be achieved in a DDQ by using the scripter.

--

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

"Joey Ebright" <joeyebright (AT) decadesoftware (DOT) com> wrote

Quote:

Hello all,

I have been trying to get a DDQ to work with an UPDATE statement without
having to use the scripting transformation. I want to instead use the
Copy
Columns transformation. However, I keep getting the following error when
executing my DTS package - "No query specification returned by Transform
status".

An exhaustive search leads me to believe it is possible, but every working
example I have seen thus far uses the scripting transformation and
overcomes
this error by setting the Main function to return a value of
DTSTransformStat_UpdateQuery. I cannot find an equivalent way to do this
using Copy Columns, either within the DTS designer or using the Object
Model
(writing Visual Basic code...).

Any help would be greatly appreciated.

-Joey

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Re: DataDrivenQuery UPDATE without using scripting

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

Re: DataDrivenQuery UPDATE without using scripting - 07-03-2003 , 03:33 PM