October 16, 2017 at 9:12 am
Hi
Thanks for all support provided here.
I have more than 200 tables in my MYSQL data source.
I am trying to figure out a quick way to :
1)Load all data in raw to Staging through SSIS package (instead of individually mapping each table in ssis) in my SQLserver.
2) Also create the table if not exist dynamically when this SSIS package run.
Thanks,
sqlsniffer
October 16, 2017 at 9:18 am
Sounds like a good opportunity to use Biml: https://www.timmitchell.net/post/2017/07/12/staging-load-with-biml/
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
October 16, 2017 at 9:32 am
TIM,
Never had any clue if something like this existed. Thanks for the article.
Are there other ways this could be done, just to explore other available options rather than individual mapping.
Thanks,
sqlsniffer
October 17, 2017 at 12:51 pm
You could do so with a script task, but generic processes such as this can be hard to debug. Alternatively, there are third-party tools that allow you to build dynamic data flows, although I've never tried that particular function.
Tim Mitchell, Microsoft Data Platform MVP
Data Warehouse and ETL Consultant
TimMitchell.net | @Tim_Mitchell | Tyleris.com
ETL Best Practices
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply