• That shouldn't be too hard, actually, you merely only map the columns you need in the OLEDB destination to the table(s) in question. However, of a more critical issue, how do you determine which rows associate to each other between the tables, and does that key come from Excel? If it's a SQL generated surrogate key, this is going to require a lot more work.


    - Craig Farrell

    Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

    For better assistance in answering your questions[/url] | Forum Netiquette
    For index/tuning help, follow these directions.[/url] |Tally Tables[/url]

    Twitter: @AnyWayDBA