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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 /* Comment problem in Execute SQL Task */

Author  Topic 

coolerbob
Aged Yak Warrior

841 Posts

Posted - 2005-07-14 : 09:21:30
Can I get an "Execute SQL Task" to accept the /* */ notation of comments.
I have a big script that I want to have run through the dts package. I dont really want to go through and take the comments out or change it to the -- notation!
Can anyone help?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2005-07-14 : 14:41:23
Did you get an error when you try it?

If you do, then you can easily put -- before each line that is highlighted in Query Analyzer by hitting ctrl+shift+c. Then copy your script back into the Execute SQL Task and see if -- works.

Tara
Go to Top of Page
   

- Advertisement -