Create View issue

Hello - I am creating a view using "Execute SQL Task" - this gives me the following error:

"The CREATE VIEW SQL construct or statement is not supported."

This worked in SQL 2000 DTS, and I know it is supported in 2k5. It is probably user error on my part - but I can't figure out what I am doing wrong.

Thanks,
Sean

Sean Trask wrote:

Hello - I am creating a view using "Execute SQL Task" - this gives me the following error:

"The CREATE VIEW SQL construct or statement is not supported."

This worked in SQL 2000 DTS, and I know it is supported in 2k5. It is probably user error on my part - but I can't figure out what I am doing wrong.

Thanks,
Sean

That's probably an error coming from the underlying data source, not from the Execute SQL Task.

Can you run the statement from outside the SSIS Designer?

-Jamie

|||

Yes - I run the create view statement in a SQL window, and it works just fine.

Is there a way to turn on some level of advanced logging? I know this should work, it just does not. Same thing with CREATE TRIGGER.

|||This was a user error - ie: me. I clicked the "Build query" button - which created the view, then when I hit "OK" it errored out - so that was more of a procedural mistake on my part. Sorry.