Where is my package saved?

Question

Where is my package saved?

Christopher Stobbs

SSC-Insane

Points: 21098
More actions
September 5, 2008 at 5:09 am

#124407

HI All,
I ran the DTS wizard from SSMS, and saved the package!
But where does it get saved to?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
SQL-4-Life

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

It should be saved to msdb on that server. In the Object Explorer in SSMS under the Connect Menu select Integration Services and then connect to the server you ran the wizard on and you will see a tree under the server with 2 folders, Running Packages and Stored Packages. Your package should be under Stored Packages -> MSDB.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 2

Thanks Jack that is awesome 🙂

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 3

HI Jack,

One more question.

How can view what this package is doing?

Can it be viewed in SSMS?

thanks

Chris

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 4

I worked out how to do it in VS, still hoping it can be done in SSMS

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Jack Corbett SSC Guru Points: 184394 More actions · Answer 5

You can't edit a package in SSMS unless it is a Maintenance Plan and you have to do these under a DB Engine connection in the Maintenance Plan area.. You have to use BIDS or VS to edit or view the steps of a package which is why BIDS is part of the SQL Server install.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

Christopher Stobbs SSC-Insane Points: 21098 More actions · Answer 6

thanks again Jack,

This is great, means I get to introduce a whole new world in my knowledge base, can't wait 🙂

----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley

:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]

SQL-4-Life

Jack Corbett SSC Guru Points: 184394 More actions · Answer 7

I'm guessing you are migrating from the DTS world to SSIS. Let me assure you that you will like SSIS better. There are some annoyances, but it is, IMHO, much easier to use SSIS.

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question