Solved

Save a SSIS package to SQL Server or File System

Posted on 2014-03-04
2
379 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
2 Comments
 
LVL 39

Accepted Solution

by:
lcohan earned 500 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

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

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

SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
Lessons learned during ten years of interviewing for SQL Server Integration Services (SSIS) and other Extract-Transform-Load (ETL) contract roles and two years of staff manager interviewing contractors.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

809 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