SSIS 2008 - Correct way of opening a ssis package

Hi experts,

 I am knew too all this.

 Ok I need to open a SSIS package so I can work on it.

 The problem I am having is how to open it up the correct way?

 I have this:


 I have VS2008 installed
 I go to File>open>  after that things do not work for me

 Please help and thanks
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
Paint us a picture of 'things do not work for me'.  Mind readers we ain't.

Usually if you're going to go into design mode on an SSIS package using VS2008 you need to open/create a solution, then add that package to your solution, then you can double-click to open the package.
Vitor MontalvãoMSSQL Senior EngineerCommented:
Can you post a print screen?
Also, a simple double-click on the file should open it in BIDS.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Amour22015Author Commented:
You mean you have too create a solution first?

Don't you do File>Open>Team Project

Then you get the Connect to Team Foundation Server menu?

The solution has already been made otherwise how would a SSIS package already exist?
This is not a new SSIS package, this is one I have been asked too update.

See Attachment please

Thanks for any help
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you trying to open a Solution, Project or a simple package file?
Your question only refers a package.
Amour22015Author Commented:
Ok when I double click on the:

I get too see 2 SSIS names

I double click on one of them and I get a:
Execute Package Utility menu

I do not want too execute this package
I want to just bring it into the source control
so I can work on it.

Please help and thanks
Vitor MontalvãoMSSQL Senior EngineerCommented:
By default it may be executing the file on double-click. Try with right-click and check if there's an option to OPEN.
Amour22015Author Commented:
Maybe I am confused about a solution/package

But I thought that a package already has a solution?

I guess this is where I get more confused:
It has this as a type:
Integration Services Configuration
Integration Services Package
There are 2 with the same SSIS names

Amour22015Author Commented:
I tried to open using the add existing package but I get this:

See Attachment:

Vitor MontalvãoMSSQL Senior EngineerCommented:
First of all you can insert the image directly in you post.
Second, the error is access denied meaning that you don't have access to open the SSIS package.
Amour22015Author Commented:
Ok, how do you insert the image directly?

Do you mean too:
Take a print Scrn.
Then paste into the window?
But I need to crop the pictures from the "Print Scrn" first.

I noticed a "Insert image" icon at the top, but that looks for a file.
Which means I need to first create the Cropped picture?

I am trying to get permission for the SSIS package Thanks
Vitor MontalvãoMSSQL Senior EngineerCommented:
Yes, you need to take a snapshot of the screen and then save it as an image instead of paste it to a Word document and save it. Then you just need to click on the "Insert Image" icon and point to the file. It's simple and let everyone see the image without downloading files.
Amour22015Author Commented:
I have never done it that way, so now is my chance too learn how?

So I take a "Print Scrn" (SnapShot)

What program do I open? to place the "SnapShot" into?
Does that program have a cropping tool?
When I click on the "Insert Image" Icon on top it asks for a file?

Vitor MontalvãoMSSQL Senior EngineerCommented:
If you don't have an image editor application every Windows comes with Paint (check in Accessories). Just paste there and save it.
Amour22015Author Commented:
Turns out I did not have the permission on the SSIS package.  Thanks for your help
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.