Post reply

SSRS report with SSIS package as a data source

  • February 8, 2010 at 2:05 pm

    #215397

    Hi folks,

    I am trying to generate a report in SSRS with SSIS pacakge as a data source.When i try to create the Shared Data Source for the report,i dont see the Integration Services type in the drop down.Do i need to change any config file???

    Please advice...

    Thanks,

    Nemo

  • February 10, 2010 at 11:02 am

    #1117023

    The site referenced below will show you the configuration changes to make.

    Configuring Reporting Services to Use SSIS Package Data

    I recently had a project which involved using SSIS as a reports datasource and it was a pain to get working initially. Now that I have some base knowledge with this process, creating future projects this way will not be so bad. Don't give up, it can be done.

  • February 12, 2010 at 10:28 am

    #1118146

    Thank u!!!!!!

    That helps...

  • February 15, 2010 at 11:34 am

    #1118897

    I could see SSIS type in the drop down.. But not able to figure out how to give the connection string for data source.

    Please suggest..

    Thanks,

    Nemo

  • February 16, 2010 at 8:40 am

    #1119321

    If you search around on the web you will probably find other connection strings that people have used, which may or may not work in your scenario. Below is the connection string that I have used. Just change the file path to where ever your package is saved.

    -f C:\SQL_Package\Report\Package.dtsx

    Additionally when you create your datasets in SSRS, you will need to use the name of the Output object from your SSIS package. So, your SSIS project should have an output object of a "Datareader Destination". You can see this object in the Data Flow Destinations toolbox in your SSIS Project. (The name being the text that you type in the white box on the object.) Once you have that in place, your dataset in the report should populate with all the fields...etc that from your SSIS package.

    Other Resources:

    Creating Report Datasets from SQL Server Integration Services

  • February 22, 2010 at 1:10 pm

    #1123227

    Hello Code2Solutions ,

    Thanks a lot it is quite useful.

    hbpank

    Thanks a lot,
    Hary

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply