September 8, 2016 at 10:42 pm
Hi Guys,
I need help and advice. I am thinking to SSIS Template for me to use over and over.
My destination will always same. However, Source will change time to time. I am thinking is it
is it possible If I have a table (Destination_Table) and Column should be all destination fields.
and configure and map the table to insert the row.
Then read header and mapping read from the table. So next time a new file comes, just configure
the table and that's it.
Please advise me, is this possible and how.
Thank You.
September 9, 2016 at 4:32 am
Not possible. Column mapping is a design-time function. There may be 3rd party addons which can help you do this, but they're not free...
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply