Solved

How to save SSIS to SQL Server in Visual Studio 2010

Posted on 2014-03-11
4
1,518 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 39

Accepted Solution

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

Assisted Solution

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

Migrating Your Company's PCs

To keep pace with competitors, businesses must keep employees productive, and that means providing them with the latest technology. This document provides the tips and tricks you need to help you migrate an outdated PC fleet to new desktops, laptops, and tablets.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
best counters for cpu high usage 3 32
SQL SELECT query help 7 41
Show Results for Latest DateTime in a View 27 25
Tsql query 6 22
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

773 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