TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
vipin jha
NA
10
9.2k
SSIS multiple table loads using single DFT
Dec 11 2014 3:54 AM
Hi,
I am new to the SSIS. I am trying to load multiple tables from my staging database to multiple tables in the data warehouse. My staging database is nothing but a database with all the tables from all my source databases copied to it. I found that each data flow task only allows to connect one source table to one destination table.
I am having
100 of SSIS package of 100 Tables
.
I want to make single SSIS package to laod all the 100 tables usning single DFT.
I have a filmaster table which containing the list of source table and destination table name, and input will be the filename , on the basis of filename my DFT will take the source and derstination table and run the package accordingly.
Is this approach is correct, or is it possible, is dynamically column mapping is possible.
Please suggets some ideas on above concern
Regards,
Vipin Jha
Reply
Answers (
5
)
How to load the last updated value from sql server 2012
automating a database backup, restore and stored proc call