Saving Visual Studio 2013 SSIS Packet

Question

Hi,

I am trying to save a packet created in VS 2013 in SQL Server 2014. But the save as option displays only file structure in my drive but no option is there for sql server !!

Answer 1

Hi,

you could connect to SSIS using SQL Server Management Studio and upload the package there via context menu "Import Package".

Cheers

Martin

Answer 2

Hi ganeshsg,

When we click “Save Copy of <package file> As” on the File menu in Project Deployment Model, we can only save the package on the disk.

Please note that the procedures in the article is about Package Deployment Model. So if we want to save a copy of package to SQL Server, we should change the Model first, then refer the steps in the article.

To convert the Model from Project Deployment Model to Package Deployment Model, please right-click the project to select “Convert to Package Deployment Model” option in the Solution Explorer. If a package uses features unique to the project deployment model, such as parameters, then the package cannot be converted. So please avoid use features unique to the project deployment model.

The following screenshot is for your reference:

If there are any other questions, please feel free to ask.

Thanks,
Katherine Xiong

---

Katherine Xiong
TechNet Community Support

Answer 3

Thanks Martin, it worked with the method suggested by Katherine

Answer 4

Thanks a lot Katherine. It worked the way you described :)

Answer 5

Thank you Katherine!