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 2008 Forums
 SSIS and Import/Export (2008)
 Execute SQL Task Editor - Invalid Comments

Author  Topic 

voudou_v
Starting Member

3 Posts

Posted - 2010-09-03 : 06:13:40
Hi,
I have created an SSIS package using Visual Studio 2005 and in the box Execute SQL Task Editor I have some sql code for testing.
I have added some comments like /* aaaa*/ or --aaaaaa
And the next line contains the execution of stored procedure like exec processlog ?,?
When I parse the query the following message appears: ‘The query failed to parse. Syntax error, permission violation, or other nonspecific error.’
If I remove the comments it works fine.
Can anybody help me…

Regards,

Vassilis Voudouris
   

- Advertisement -