Hi,
I need data from two datasources. From the first datasource a get only one row. Then I need to use one of the values in this row to filter the next query. I couldn't make it to work. Is it possible Suggestions on how to do this
Tomsi
Queries dependent on results from other datasets.
Hot Topic
- How to run an exe in the SSIS scripting task
- Limited number of assemblies available in Visual Studio SQL Server Projects
- Sequel 2005 installation Perflib problem
- Designing Aggregations
- SSIS with MSDTC ERROR!!!
- SSIS Deployment Question
- Package could not be loaded
- ole db destination or sql server destination
- Will Work for Help SQL 2k5 SP1 Installation issue (log attached)
- Upgrade advisor and Reporting Services...
SQL Server
- Need some advice..kinda urgent!
- Hide matrix rows?
- SQL Transact: Subquery
- Semi-additive measures in AS2005 Standard Edition
- "Could not find schema information ..." error in XSD annotation
- The SQL Network Interface library was unable to register SPN. Error: 0x490
- Issue with SqlUserDefinedAggregate
- SQL server 2005 Express remote connection problem via SSMSE
- SSIS delta
- Framework 2.0 changes - TCP Provider, error: 0 - An existing connection was forcibly closed by the remote host.
Queries dependent on results from other datasets.
Republican Conservative
One possible solution is to create internal parameter that will take default value from 1st data source.
When you can use this parameter in the second data set.