Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How to save SSIS to SQL Server in Visual Studio 2010

Posted on 2014-03-11
4
Medium Priority
?
1,829 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
  • 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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Windocks is an independent port of Docker's open source to Windows.   This article introduces the use of SQL Server in containers, with integrated support of SQL Server database cloning.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Suggested Courses

572 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