Add multiple update statements in DTS package

[cocopud]

I am trying to create a dts package. When I get to the Query Statement area, I copied the statements that I have in Query Analyzer to this area. There are 4 Update statements that are separated by GO. When I try to run it I get:
Statment(s) could not be prepared
Line 29: Incorrect syntax near 'Go',
Line 22: "
Line 14: "
Line 7: "
Context: Error calling Prepare on the command.

Does anyone now how to add in multiple statments in the query?

 

[SQLDenis]

Go is a batch termiminator
Put it in 4 different tasks or better yet create a stored procedure with the 4 update statements and call that from your DTS packages

“I sense many useless updates in you... Useless updates lead to fragmentation... Fragmentation leads to downtime...Downtime leads to suffering..Fragmentation is the path to the darkside.. DBCC INDEXDEFRAG and DBCC DBREINDEX are the force...May the force be with you" --

http://sqlservercode.blogspot.com/