Results 1 to 3 of 3

Thread: Update SQL Server table from SSRS

  1. 12-25-2015, 04:14 PM #1
    donalejandro
    donalejandro is offline Registered User
    Join Date
    Apr 2013
    Posts
    39

    Update SQL Server table from SSRS

    Hello,

    I am using the latest version of SSRS I have a report pulling data from AS400 on a nightly basis - subscription. What I want to do is have the data populate from the nightly run into a SQL table (already created) each night at least 4 rows will get updated to the table. I have no idea in how to do that automatically if anybody has an idea I would appreciate. I just need a step by step process on this. Thank you in advance.
    Reply With Quote Reply With Quote
  2. 12-25-2015, 08:23 PM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You may check ssis for that.
    Reply With Quote Reply With Quote
  3. 12-25-2015, 09:57 PM #3
    donalejandro
    donalejandro is offline Registered User
    Join Date
    Apr 2013
    Posts
    39
    True, that would be my first choice, but due to limited resources IT unable to find the disk (SQL Server 2014 to add SSIS). I did heard awhile back someone actually did update SQL table via SSRS. Thank you anyways
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules