SSIS and DMO - SQL Server Forums

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 2005 Forums

SSIS and Import/Export (2005)

SSIS and DMO

Author

Topic

RIKIL
Starting Member

20 Posts

Posted - 2010-07-28 : 12:17:25

I have a small bit of code that generates a create table statement from an existing table:

Dim Server As New SQLDMO.SQLServer
Dim Database As New SQLDMO.Database
Dim Table As New SQLDMO.Table

Server.Connect(ServerName, LoginName, Password)
Database = Server.Databases.Item(DatabaseName)
Table = Database.Tables.Item(TableName)

Script = Table.Script

This code works fine in a console app but what I really need to do is get the same thing (the create table statement) from within SSIS. I don't see a way to add a reference to SQLDMO so there is some information I am missing. Am I not able to do this? Is there a built in way to get a create table statement like this using SSIS?

tybaltzeke
Starting Member

28 Posts

Posted - 2010-09-01 : 14:49:13

why not put in execute sql task?

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources