Using SQL Server 2005 SSIS and SSRS. I have a package that gathers data from and Oracle 10g database and a DB2 database, and does some processing to provide a merged dataset. When I built the package, I hard-coded the value of an identifier, but now I need to assign a variable to that value. This is where it gets really fun...the value passed in must come from the user who is running the report in Reporting Services.
Has anyone attempted to do this before? If so, could you tell me (in great detail) how to go about this?
Here's more info on what I'm trying to achieve:
A report that shows all of the parts that are included in a given catalog. The Oracle database has the catalog and part information and the DB2 database has the cost(s) to produce the parts. The user needs to be able to enter a catalog identifier (several catalogs each year) to see which parts were (and weren't) included, and the cost associated with producing the parts.
Has anyone attempted to do this before? If so, could you tell me (in great detail) how to go about this?
Here's more info on what I'm trying to achieve:
A report that shows all of the parts that are included in a given catalog. The Oracle database has the catalog and part information and the DB2 database has the cost(s) to produce the parts. The user needs to be able to enter a catalog identifier (several catalogs each year) to see which parts were (and weren't) included, and the cost associated with producing the parts.