DROP Temp Table or any scripts

Hi,

What control can I use to put any scripts like that?

ExecuteSQLTask lets me do just sql query.

I need to have something like this.

USE [DB1]

GO

IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Lookup]') AND type in (N'U'))

DROP TABLE [dbo].[Lookup]

or Create

CREATE TABLE [Lookup] (
[MD_ID_Old] INTEGER,
[MD_ID_New] uniqueidentifier
)

I need to find the way to use scripts in SSIS.

Thanks.

Have you tried your sql statements in ExecuteSQLTask? This components exists for executing any sql statement. There is a SourceType property that allows you to point to a file [your script] and you can execute the sql statements that way.

Hope this helps...

Senthil

|||Thanks.