Results 1 to 3 of 3

Thread: Update SQL Server table from SSRS

  1. #1
    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.

  2. #2
    Join Date
    Sep 2002
    Posts
    5,938
    You may check ssis for that.

  3. #3
    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

Posting Permissions

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