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
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply