Hi,
I need some suggesstion regarding which SSIS tasks to use regarding my job in hand. Basically what I need is to extract data from joining multiple tables and then load to a particular output database.
How I can go about it
Thanks
SSIS Tasks
Hot Topic
- Storing an array in an SSIS variable
- SSIS Tutorial - Package configuration problem
- SSIS Import and Export Wizard Data Sources
- Do not export navigations
- error- microsoft ODBC sql server driver - timeout expired
- How to set up trusted connection on SSAS 2005?
- Using a sproc as a source within Dataflow
- extracting sql table column names
- sql question
- Replication between SQL CE 2.0 and SQL Server 2005 not working
SQL Server
- String truncate error
- sql mobile question
- Unable to start NS instance service
- All possible combination in a where condition
- ReportServer activation logs
- Passing Variables
- Install SSMSE - Installation failed
- I can't change my sql login user's password in SQL Server 2005 Express
- "...conversion between types DT_I1 and DT_I2 is not supported"
- Practical Uses for the "Embedded Code" functionality
SSIS Tasks
Emac80
Are the tables in the same database If so you should write a SQL statement to do the join in an OLE DB Source Adapter.
if they are not in the same database then look at using MERGE JOIN component.
-Jamie