Avatar of Amour22015
Amour22015
 asked on

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:

\\Servername\Folder\subfolder

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

 Please help and thanks
Microsoft SQL ServerMicrosoft SQL Server 2008SSISSQL

Avatar of undefined
Last Comment
Amour22015

8/22/2022 - Mon
SOLUTION
Jim Horn

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
ASKER CERTIFIED SOLUTION
Vitor Montalvão

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Amour22015

ASKER
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?
<Server>
<add>

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
SnapShotTeam.docx
Vitor Montalvão

Are you trying to open a Solution, Project or a simple package file?
Your question only refers a package.
Amour22015

ASKER
Ok when I double click on the:
\\Servername\Folder\subfolder

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
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy
Vitor Montalvão

By default it may be executing the file on double-click. Try with right-click and check if there's an option to OPEN.
Amour22015

ASKER
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

Thanks.
Amour22015

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

See Attachment:


Thanks
SnapShotOpen.docx
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.
Vitor Montalvão

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.
Amour22015

ASKER
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ão

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.
Your help has saved me hundreds of hours of internet surfing.
fblack61
Amour22015

ASKER
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?
Cause:
When I click on the "Insert Image" Icon on top it asks for a file?

Thanks
Vitor Montalvão

If you don't have an image editor application every Windows comes with Paint (check in Accessories). Just paste there and save it.
Amour22015

ASKER
Turns out I did not have the permission on the SSIS package.  Thanks for your help
⚡ FREE TRIAL OFFER
Try out a week of full access for free.
Find out why thousands trust the EE community with their toughest problems.