creating user databases on ssrs server

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  October 9, 2013 at 10:31 am

  #277895

  Hi,

  Can I create an user database to hold the tables that will have data imported from multiple servers using SSIS package.

  I have 4 servers and I will get data from all the four servers and planning import all that data onto a user database on my reporting server for reporting purpose.

  Is that recommended?

  Thanks.

• Alan Burstein

  SSC Guru

  Points: 61141

  More actions

  October 9, 2013 at 11:00 am

  #1657234

  You are describing the thing that SSIS was designed to do. I don't see anything wrong with that provided you are using SSIS according to a set of best security practices.

  "I cant stress enough the importance of switching from a sequential files mindset to set-based thinking. After you make the switch, you can spend your time tuning and optimizing your queries instead of maintaining lengthy, poor-performing code."

  -- Itzik Ben-Gan 2001

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  October 9, 2013 at 11:11 am

  #1657236

  You can create user databases on an SSRS SQL server instance if you want and if the server has the resources for it.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question

• sql_novice_2007

  Hall of Fame

  Points: 3307

  More actions

  October 9, 2013 at 12:49 pm

  #1657287

  Thanks.