dbTalk Databases Forums  

execute sql and db2

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


Discuss execute sql and db2 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
AT
 
Posts: n/a

Default execute sql and db2 - 07-11-2006 , 08:21 AM






Hi,

My DTS has odbc connection pointing on DB2 UDB 7.2 and execute sql
task

with update query

dts return error where is no rows updated

db2 message code SQL0100W

I want dts retrun scucces if the no row updated

I am trying to avoid extra step to check if the any records to update.

Thanks
Alex


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.