Improve company productivity with a Business Account.Sign Up

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

How to deploy ssrs and ssis objects to antoher server

I've developed a set of SSIS DTSX files and associated reports on my development station.   I now need to move them to a production server.  What is the best way to update my objects to point to them to the other database and file systems?   Ideally I want things so I can quickly change them back to my laptop for development.
0
canuckconsulting
Asked:
canuckconsulting
  • 2
  • 2
2 Solutions
 
ValentinoVBI ConsultantCommented:
You need to look into package configuration.  A method that's used a lot is called indirect package configuration.  In this method you set up an environment variable that points to a configuration XML file or table.  So your development machine can point to a configuration file/table on your PC while the production environment will have an environment variable that points to the production configuration.

Details: Best Practices for Integration Services Configurations [MSDN]
0
 
canuckconsultingAuthor Commented:
Thanks...this is going to be very useful.

One problem I have just run into is that I can't seem to deploy to my production server.  I have developing using BIDS on the Visual Studio 2012 shell against a SQL Server 2012 db.  After creating the default catalogue I have no problems deploying.

Our production server is SQL Server 2008 and when I point my SSIS deployment destination to it I get an error advising that the version of SQL Server does not support the selected operation as shown below.  Do I need to configure 2008 in some way to deploy SSIS ?

error
0
 
ValentinoVBI ConsultantCommented:
Ouch!  Packages created with SSIS 2012 are not backwards-compatible and thus cannot be deployed to 2008...  So if you really want to get this to work you either need to develop your packages using BIDS 2008 or install an instance of SSIS 2012 on that production server...
0
 
canuckconsultingAuthor Commented:
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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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