December 25, 2015 at 2:12 pm
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.
December 25, 2015 at 2:46 pm
First off, this is an Integration Services question. You would create all the steps there and run it via a Job. I think you just posted in the wrong place. The fact that you're using the data in your report is really only tangential to the real problem.
December 25, 2015 at 7:51 pm
Understand this I have heard others have actually did what I asking. I am very limited of the tools I used. So that is why I asked the question. I preferred to use SSIS, but my options are limit. That's all.
December 25, 2015 at 8:48 pm
Alex,
this part: "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." would have to be done by a stored procedure or something similar. You'd have to create a job that runs the stored procedure every night, and then you could do whatever.
The question has nothing to do with SSRS at all. SSRS cannot modify data, nor can it initiate it.
December 25, 2015 at 10:08 pm
Thanks pietlinden,
I figure I would have to do a SP. Thanks for the tip.
December 26, 2015 at 9:36 am
Alex,
You'd just do something like
SET NOCOUNT ON;
INSERT INTO DestTable
SELECT [fieldlist] FROM SrcTable WHERE...
in your stored procedure and then just call it in a job that you schedule.
December 26, 2015 at 12:46 pm
Thanks I appreciate the tip!
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply