Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1903
  • Last Modified:

How to save SSIS to SQL Server in Visual Studio 2010

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
hpsuser
Asked:
hpsuser
  • 2
  • 2
2 Solutions
 
lcohanDatabase AnalystCommented:
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
 
hpsuserAuthor Commented:
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
 
lcohanDatabase AnalystCommented:
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
 
hpsuserAuthor Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now