Import SSIS Project in Denali CTP1

by Allan Mitchell 11 Nov 2010 22:31

For years Analysis Services has had the ability to take an existing database from a server and reverse engineer it into a BIDS project.  This is extremely useful when all you have is the running instance of the database and the project that created it has long since disappeared.  Reverse engineering has never been a feature of SSIS until now.

Let me walk you through the simple steps.

The first step is that you obviously have to have a project deployed to an SSIS Catalog.  I will do a video on this soon but in case you can’t wait then my good buddy Jamie Thomson has written it up here

DeployedProject

As you can see I have a project called imaginatively “Denali1” with one package “Package.dtsx

The next thing we need to do is fire up BIDS and choose the right project type (Integration Services Import Project)

ProjectSelect

Now we just follow the wizard.  We make sure we specify on which server to find the Catalog and in which folder to look for the project.

SpecifyLocation

Next the setting are validated and we are greeted with the familiar review screen before the creation of our new project from the deployed project happens

review

Hit Import and away we go

Success

The result is just what we wanted.

result

Add comment

  Country flag

biuquote
  • Comment
  • Preview
Loading

Widget Amazon Book not found.

Object reference not set to an instance of an object.X

RecentComments

Comment RSS