How can we combine more than 2 connectors in SSIS?
I am very new to SSIS. I have a task of taking data from ODBC source A, then transport that data to access, thereafter to SQL. I believe SSIS can do this task. However, according to various examples I have seen, they use a single source and destination. I couldn't find any method for using 3 or more connectors at a time. TO summarize again, I have to migrate data in following manner: ODBC source A -> Access -> SQL Server (when import is over at access)
How can I achieve this?
Please don't ask me to remove access or any other data source as proper mappings and data in SQL server is moved if the ODBC data goes into Access first.
From what I can gather you only want the data copied to its final SQL Server destination after it has been copied to Access.
- Copy data from ODBC Source to Access
- Then copy data from Access to SQL Server
You can use 2 data flows to accomplish that is SSIS:
- Math.Sin() gives incorrect value
- How to run my python script when the sunOS is start booting
- Express-session: not resetting cookie expiration on each request
- Getting a stack overflow exception when normalizing a vector
- Edit default summary function in R gives error for multiple variables
- What was a For loop? Why isn't it needed in R?
- How to use download button in shiny and save results in various formats (csv, texte, pdf, spss...)?
- Why are there two assignment operators, `<-` and `->` in R?
- lm()$assign: what is it?
- How to get the value of list(...) in R and S functions
- Design matrix for MLM from library(lme4) with fixed and random effects
- how to generate elements not included in my sample
- Create a matrix with gradually changing values without a for loop
- Emacs ESS and S-plus ( S+ ) 8.1 compatability
- How to lag date-index in a time-series in R?
- Nonlinear regression in R / S
- Calling R from S-Plus?