Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How to save SSIS to SQL Server in Visual Studio 2010

Posted on 2014-03-11
4
Medium Priority
?
1,768 Views
Last Modified: 2016-02-10
Hello,

In VS2008, I was able to save a SSIS to a sql server by doing a FILE->SAVE COPY OF...In VS2010, it seems to only give me the option of saving to a file system...any suggestions how I can do this in VS2010?

Thanks!
0
Comment
Question by:hpsuser
[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
  • 2
4 Comments
 
LVL 40

Accepted Solution

by:
lcohan earned 1500 total points
ID: 39921680
Please see Mike Yin's answer to the similar question below and note that you may need to re-design the package from scratch in 2008:

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/e9e07f63-7e92-4ba6-975e-69150a3bacf9/deploying-ssis-packages-created-in-visual-studio-2010-to-sql-sever-2008-r2
0
 

Author Comment

by:hpsuser
ID: 39921773
Thanks Icohan, so if I'm tracking correctly after reading Mike Yin's answer, I cannot save a SSIS package designed in VS2010 to a SQL Server 2008 instance?  (meaning I need to build the SSIS package in VS2008)?
0
 
LVL 40

Assisted Solution

by:lcohan
lcohan earned 1500 total points
ID: 39921809
That is correct however I would try to save it as a file first then use SQL SSMS and try to import it into SQL Server - sorry I don't have right now such an environment to try that by myself.
0
 

Author Comment

by:hpsuser
ID: 39926864
Thanks Icohan...unfortunately server permissions won't allow me to try the import like you suggested, so I'll keep using VS2008 for now.   Thanks!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

609 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