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.
| Author |
Topic |
|
Anand.A
Posting Yak Master
109 Posts |
 Posted - 2012-01-19 : 00:34:58
|
| HIi create a package in ssis.in that i used execute sql taskin that task i wrote 2 update statement my connection string is connected with oracle server..if i use that 2 statement in sql server it worked but in oracle its not working how to solve thisupdate emp set empno=10 where ename='jack'update emp set ename='scott' where empno=12i gave semi-column also but still its shows erroranand |
|
|
webfred
Master Smack Fu Yak Hacker
8781 Posts |
Posted - 2012-01-19 : 04:50:09
|
Try GO in the line between the statements
No, you're never too old to Yak'n'Roll if you're too young to die.edit: like this:update emp set empno=10 where ename='jack'GOupdate emp set ename='scott' where empno=12 |
 |
|
|
|
|
|
multiple query in execute sql task