Solved

SSIS 2012

Posted on 2014-04-22
2
167 Views
Last Modified: 2016-02-10
Hello All,

I have several SSIS jobs that i created in SSIS. Now problem - how do i do a save-as for an entire ssis job and save it with a different name?
Also , how to find where all my ssis jobs are getting saved?

thank you
0
Comment
Question by:Rayne
2 Comments
 
LVL 8

Accepted Solution

by:
ProjectChampion earned 500 total points
ID: 40015270
Since 2012 the SSIS solutions are like stored like proper VS solutions, i.e. You ave a solution, that can have one or more projects of various types, with each project consisting of one or more packages. The solution itself is stored in th efiule system, but the package can be either deployed into SSIS catalog (preferred option) in which case you can see them in management studion under the appropriate project under "Integration Services Catalogs" folder under the pertinent server... or you can deploy them as in previous options either into file system or SQL Server (i.e. msdb database).

To save a project with a different name, you can save the whole project with a different name, or try add existing... (project or package) and grab it from its existing location in the file system.
0
 

Author Closing Comment

by:Rayne
ID: 40016980
thank you Dara
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Suggested Solutions

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…

706 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

Need Help in Real-Time?

Connect with top rated Experts

20 Experts available now in Live!

Get 1:1 Help Now