You can add SQL Task with respective connection and
validate your data. When successfuly completed copy your
objects.
Joanna
>--Original Message--
>I have a package that contains an Copy Objects Task. I
want to have a step
>to check a value in another table before executing the
copy task. Not sure
>how to accomplish this. Any help would be greatly
appreciated. Thanks.
>.
>Ok. How would I make not execute the next step if the validation failed?
"Joanna" wrote:
> You can add SQL Task with respective connection and
> validate your data. When successfuly completed copy your
> objects.
> Joanna
>
> want to have a step
> copy task. Not sure
> appreciated. Thanks.
>
Tuesday, February 14, 2012
DTS Help
Labels:
andvalidate,
completed,
connection,
copy,
database,
dts,
joannagt-original,
microsoft,
mysql,
oracle,
respective,
server,
sql,
successfuly,
task,
yourobjects
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment