Using SSIS to build a database from a VS2005/2008 database project

Question

How do I allow an SSIS package to consume a Visual Studio 2005 or 2008 Database project which houses the creation scripts for the tables and other objects (note: this is not Visual Studio Database Edition - just Pro with Business Intelligence)?

The idea is to use this to recreate my test instance by building the schema from source safe and the data from prod.

I have access to both VS2005 and 2008 Pro and this is hitting Sql Server 2005 for both Prod and Test.

bart · Accepted Answer · 2011-12-17 21:31:12Z

1

The short answer is, you cannot "allow an ssis package to consume a VS 2005 or 2008 db project". I am not sure why you want to use SSIS to run the create scripts. You can run the scripts from sqlcmd utility.

If you still want to use SSIS, this is what I would do:

create a deployment script (VS for DB Pro can do that)
create a package
in your control flow, use Execute Process Task and configure it to run sqlcmd with the script file as your input

edited Dec 17, 2011 at 21:31

user212218

answered Apr 29, 2009 at 20:22

bart

311 bronze badge

Sign up to request clarification or add additional context in comments.

Comments

John Welch · Accepted Answer · 2009-08-10 00:54:35Z

0

You can call the scripts in the DB project through Execute SQL tasks in the SSIS package. However, there's not a direct way to consume them.

answered Aug 10, 2009 at 0:54

John Welch

562 bronze badges

Collectives™ on Stack Overflow

Using SSIS to build a database from a VS2005/2008 database project

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related