none
Upload a CSV file as parameter to SSRS report RRS feed

  • Question

  • Hi,

    I'm looking for a solution to upload CSV file as parameter in SSRS.

    Is there any way to do that in SSRS?

    Thanks.

    Hamid

    Thursday, July 17, 2014 1:55 AM

All replies

  • You can do it in two steps

    1. Use SSIS or Export Import wizard to dump the csv data to a table

    2. use the table as source for a dataset created in your report and use that dataset to fill your report parameter


    Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs

    Thursday, July 17, 2014 2:06 AM
  • Thanks for your help.

    The csv file is a parameter uploaded by users.

    For example in a report users have to send their TagId as CSV and report return the data based on the CSV file uploaded. User might upload 100 TagId or just 10 or any number of them.

    Is that make sense?

    Thursday, July 17, 2014 2:10 AM
  • Did you ever find a workaround for this?
    Thursday, September 19, 2019 2:57 PM