Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Import data into SQL 2008 R2

Answered Import data into SQL 2008 R2

  • Wednesday, February 13, 2013 11:18 AM
     
     
    Sign In to Vote
    0

    Hi,

    I have a report in SCCM , that results in data of a SCCM client like host name, make, model, CPU, RAM etc….some fields that we use. Then there are few dashboards that are created using this data, in SRS, kind of graphical repesentation for business. Now I have task at hand, to include Work Group/Unix servers information as well into these dashboards. As SCCM doesnt manage them we plan to add their data manually. I am thinking of below to achieve this, but appreciate your comments/suggestions, either in general or from past experience of similar executions 

    1. Create a temp table, which takes all values from “all in one”  reports (then automate to update this temp table on some frequency)
    2. Enable customer with some forms or “Import wizard of SQL” to load data of Unix/WG machines, into above table, which will fill exactly same fields that I need for report.
    3. Modify SRS dashboard a bit to represent new category etc.

    2# Point seems crux and looking for real suggestions here on what tools best suits and stuff like that. Do you recommend Excel  or any other HTA kind of tools to enter data into specified SQL Table

    Thanks, Vasu

    Vasu

     

All Replies

  • Wednesday, February 13, 2013 2:03 PM
     
     Answered
    Sign In to Vote
    0
    Hi, As long as you are able to get as Dataset into SSRS - then you will be able to display the data in whatever format you want.

    Please Mark posts as answers or helpful so that others can more easily find the answers they seek.

     
  • Tuesday, March 05, 2013 2:36 PM
     
     
    Sign In to Vote
    0

    Thanks All,

    I did use using SQL Import Wizard and used a flat file option (.csv file). Then created a SSIS package as well for automation and for consistency purposes. So our customer uses that CSV file to keep it updated and then runs SSIS package that will udpate the table in SQL DB with that static data

    --- Vasu

    Vasu