Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Render SSRS Report from SSIs package Expand / Collapse
Posted Tuesday, August 24, 2010 10:35 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Monday, September 12, 2011 8:52 AM
Points: 5, Visits: 80
I am populating Dimension table "D_RepLicense" and for this dimension I am fetching RepID from "D_Rep" dimension by joining RepCode and BDID. Ideally I should have RepID for all BDID and RepCode but It is not. For 5100 distinct BDID and RepCode , I cant find respected RepID from "D_Rep"(Meaning: I dont have those BDID and RepCode available in D_Rep). So I created ssrs report of these BDID and RepCode for which I am not finding respected RepID.

And I have to render this report from SSIS package to cencern person from report server.

Can anyone please help me in achieving this. I will have to use Script Task that I know. but I would need some more information.

Thanks . Please help me.
Post #974289
Posted Thursday, August 30, 2012 1:24 PM


Group: General Forum Members
Last Login: Friday, September 12, 2014 3:51 AM
Points: 19, Visits: 381
I am not clear about what you are asking but for rendering reports from SSIS package refer one of my blog post.

Let me know your issues while developing the code


Sunil Reddy

Post #1352453
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse