Modifying SSIS package stored in File Systesm

Question

Post reply

Modifying SSIS package stored in File Systesm

sql_novice_2007

Hall of Fame

Points: 3307
More actions
June 11, 2014 at 11:46 am

#286419

Hi,

I have a ssis package stored in file system and I need to modify this package.

How can I do this?

THanks.

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

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

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 1

If you already have a Visual Studio solution that contains the package, open that one and edit the package.

If not, either create a new solution or use an existing one and add the package to that solution.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 2

I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I can see the package in file system under stored packages on management studio when I connect to SSMS as an admin.

If I right click on the package I am getting an option 'Import Package'.

But how can I download the stored package?

Thanks,

Hari.

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 3

sql_novice_2007 (6/12/2014)

I don't have the package. It was a very old one and I recently joined in the company and the previous DBA might have had it but now I can see the package in file system under stored packages on management studio when I connect to SSMS as an admin.

If I right click on the package I am getting an option 'Import Package'.

But how can I download the stored package?

Thanks,

Hari.

There should be an export option as well.

Import and Export Packages (SSIS Service)

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

sql_novice_2007 Hall of Fame Points: 3307 More actions · Answer 4

sql_novice_2007

Hall of Fame

Points: 3307

June 13, 2014 at 10:40 am

#1721566

I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

Thanks.

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 5

Koen Verbeeck

SSC Guru

Points: 259015

June 13, 2014 at 11:51 am

#1721604

Can you take a screenshot of the context menu that you get when you right click on the package?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Eirikur Eiriksson SSC Guru Points: 182631 More actions · Answer 6

Eirikur Eiriksson

SSC Guru

Points: 182631

June 13, 2014 at 12:23 pm

#1721624

sql_novice_2007 (6/13/2014)

I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

Thanks.

You have to use BIDS or SSDT, not SSMS. SSMS has no option of editing/developing SSIS packages.

😎

Koen Verbeeck SSC Guru Points: 259015 More actions · Answer 7

Eirikur Eiriksson (6/13/2014)

sql_novice_2007 (6/13/2014)

I am not seeing the export option even though I connected to SSMS as an administrator and I have sysadmin privileges.

Thanks.

You have to use BIDS or SSDT, not SSMS. SSMS has no option of editing/developing SSIS packages.

😎

Yes, but you need SSMS to find the package stored on the server and export it to your filesystem so you can edit it with BIDS 😉

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP