How do I edit and existing SSIS Package?

[Kev]

Hi,

I have been using MS SQL Server 2000 for several years, having set up a
number of DTS Packages (some of which have been allocated to Jobs) during
this time.

We have now moved over to SQL Server 2005, and I have managed to run the
migration routine to copy these DTS routines over to '05 as SSIS Packages. I
have also managed to find out how to incorporate these SSIS Packages in the
new Jobs that I require.

However, I need to edit the SSIS Packages, for which I appear to need the
'SQL Server Business Development Studio' (the '05 version). This will not
install on the SQL Server [2005] box, so I have installed on my desktop PC,
together with the SQL Server Management Studio for '05.

However, I am unable to discover how to actually even find (let alone edit)
these SSIS Packages - or even a couple of new test ones that I subsequently
created direct from the '05 SQL Server Management Studio.

Can someone give me a brief "idiot's guide" on how to find, open and then
edit (although I suspect that the latter should fall into place easily) SSIS
Packages?

Many thanks.

[Bob Barrows]

Post by Kev
Hi,
I have been using MS SQL Server 2000 for several years, having set up
a number of DTS Packages (some of which have been allocated to Jobs)
during this time.
We have now moved over to SQL Server 2005, and I have managed to run
the migration routine to copy these DTS routines over to '05 as SSIS
Packages. I have also managed to find out how to incorporate these
SSIS Packages in the new Jobs that I require.
However, I need to edit the SSIS Packages, for which I appear to need
the 'SQL Server Business Development Studio' (the '05 version). This
will not install on the SQL Server [2005] box, so I have installed on
my desktop PC, together with the SQL Server Management Studio for '05.
However, I am unable to discover how to actually even find (let alone
edit) these SSIS Packages - or even a couple of new test ones that I
subsequently created direct from the '05 SQL Server Management Studio.
Can someone give me a brief "idiot's guide" on how to find, open and
then edit (although I suspect that the latter should fall into place
easily) SSIS Packages?
Many thanks.

I'm sure someone's done an illustrated guide for this that can easily be
found via google, but until you find it:
Open BDS (it's really Visual Studio) and when prompted, create an
Integration Services project. After it chugs away, you will be presented
with a screen and (I think) an empty package called package1.dts will be
displayed. over on the right, you should see a window titled "Solution
Explorer", displaying a tree view of your project. Right-click the "SSIS
Packages" node and select "Add Existing Package". Packages can be stored
either in the file system or on a SQL Server. It sounds as if yours are
saved in SQL Server, so simply enter the name of the server then click
the button next to the "Package" textbox to navigate to your package.
Select it, click OK, and off you go.

[Kev]

Hi, Bob.

Many thanks for that - well on the way to getting everything re-created on
the '2005 system.

One further question: I have several SSIS data import packages on the new
(2005) SQL Server that I no longer need and wish to delete. Whilst I can
delete them from the list built up in the 'Solution Explorer' noted below,
this only removes them from that list but does not permanently delete them.
Is there a way of permanently deleting them?

Many thanks for your assistance.

Kevin

Post by Bob Barrows

Post by Kev
Hi,
I have been using MS SQL Server 2000 for several years, having set up
a number of DTS Packages (some of which have been allocated to Jobs)
during this time.
We have now moved over to SQL Server 2005, and I have managed to run
the migration routine to copy these DTS routines over to '05 as SSIS
Packages. I have also managed to find out how to incorporate these
SSIS Packages in the new Jobs that I require.
However, I need to edit the SSIS Packages, for which I appear to need
the 'SQL Server Business Development Studio' (the '05 version). This
will not install on the SQL Server [2005] box, so I have installed on
my desktop PC, together with the SQL Server Management Studio for '05.
However, I am unable to discover how to actually even find (let alone
edit) these SSIS Packages - or even a couple of new test ones that I
subsequently created direct from the '05 SQL Server Management Studio.
Can someone give me a brief "idiot's guide" on how to find, open and
then edit (although I suspect that the latter should fall into place
easily) SSIS Packages?
Many thanks.

I'm sure someone's done an illustrated guide for this that can easily be
Open BDS (it's really Visual Studio) and when prompted, create an
Integration Services project. After it chugs away, you will be presented
with a screen and (I think) an empty package called package1.dts will be
displayed. over on the right, you should see a window titled "Solution
Explorer", displaying a tree view of your project. Right-click the "SSIS
Packages" node and select "Add Existing Package". Packages can be stored
either in the file system or on a SQL Server. It sounds as if yours are
saved in SQL Server, so simply enter the name of the server then click
the button next to the "Package" textbox to navigate to your package.
Select it, click OK, and off you go.
--
HTH,
Bob Barrows

[Bob Barrows]

This can be done in SSMS - you need to connect to "Integration Services"
instead of "Database Engine" and delete them from there.
I would imagine you could also use a sql statement to delete them from
the msdb database.

Post by Kev
Hi, Bob.
Many thanks for that - well on the way to getting everything
re-created on the '2005 system.
One further question: I have several SSIS data import packages on the
new (2005) SQL Server that I no longer need and wish to delete.
Whilst I can delete them from the list built up in the 'Solution
Explorer' noted below, this only removes them from that list but does
not permanently delete them. Is there a way of permanently deleting
them?