Thank you. Works like a charm

I'm not calling via script task, this is a regular dtsx package and it does not even have any script components in it.

This pop up comes after the validations of...

Thank you Luis C

CREATE TABLE sqlText (ID int , line NVARCHAR(MAX),referenced_entity_name VARCHAR(1000) )

INSERT INTO [sqlText] ([Id],[line],[referenced_entity_name])VALUES(8712,'CREATE view [dbo].[AZLJ_RPT_V_STAT_CVLDISPOSITION] as

','AZLJ_RPT_V_STAT_CVLDISPOSITION')

INSERT INTO [sqlText] ([Id],[line],[referenced_entity_name])VALUES(8713,'/************************************************************************************

','AZLJ_RPT_V_STAT_CVLDISPOSITION')

INSERT INTO [sqlText] ([Id],[line],[referenced_entity_name])VALUES(8714,'Name:AZLJ_RPT_V_STAT_CVLDISPOSITION

','AZLJ_RPT_V_STAT_CVLDISPOSITION')

INSERT INTO [sqlText] ([Id],[line],[referenced_entity_name])VALUES(8715,'Created By:Suganya

','AZLJ_RPT_V_STAT_CVLDISPOSITION')

INSERT INTO [sqlText] ([Id],[line],[referenced_entity_name])VALUES(8716,'Created...

result set

TABLE NAME ...

I don't think this solves my question.

ohh ok, that is good if they are ignored by SQL.

But, how do i get the list of where clauses from the definition.

I'm not sure what your saying here.

Please explain. Thanks,