?
Solved

Save a SSIS package to SQL Server or File System

Posted on 2014-03-04
2
Medium Priority
?
386 Views
Last Modified: 2016-02-10
Hi all.

I'm working with our SQL Server 2008 and want to create a new SSIS package via the SQL Server Business Intelligence Development Studio, but I have a question as far as saving it to SQL Server or File System.

Which is the best practice? And why?

Also, when I create a new package and try to save it, I don't see the option to save it to SQL Server, it just asks me for a path. How can I save it to SQL Server?

Thank you in advance!
0
Comment
Question by:printmedia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 2000 total points
ID: 39904155
"How can I save it to SQL Server?"

You can use VS and create your SSIS packages as files then Import those into a SQL Server or for instance on a simple data Import/Export you can do that by using SQL SSMS under Database Tasks import/export wizard that will ask you at the end where you want to save it - File or Server?

As far as Best Practice...I always saved them as File so I can save them to my Source Safe repository and for versioning purpose.
0
 

Author Comment

by:printmedia
ID: 39904180
Ok, here's what I plan to do and let me know if this is ok:

(1) I  create the SSIS package in BI and save it to "File" which will save it on a secured folder on my network that gets backed up nightly.

(2) Then I go to "Integrated Services" and Import it to: Stored Packages --> MSDB.

(3) Then I go to the Microsoft SQL Server Management Studio and create a Job to run my newly created SSIS package every day.

Is this a correct way of doing it? If I needed to make changes to the SSIS package would I have to open it again in BI save it and then "reimport" it in Integrated Services like I did in step (2)?
0

Featured Post

Optimize your web performance

What's in the eBook?
- Full list of reasons for poor performance
- Ultimate measures to speed things up
- Primary web monitoring types
- KPIs you should be monitoring in order to increase your ROI

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article I will describe the Detach & Attach method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
My client has a dictionary table. They're defining a list of standard naming convention. Now, they are requiring my team to provide us a mechanism how to match new incoming data with existing data in their system.
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
In this video, Percona Solutions Engineer Barrett Chambers discusses some of the basic syntax differences between MySQL and MongoDB. To learn more check out our webinar on MongoDB administration for MySQL DBA: https://www.percona.com/resources/we…

770 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question