Best approach

  • I have a task of importing 3 different files into a datamart db table. I am new to ssis and need some help as for someone to guide me to what would be the best approach to accomplish my task. I have the following scenario:

    3 different files in the following formats:

    XML, XLS, CSV

    Need to import them into a table with the following data types:

    varchar(1) to varchar (8000)

    smalldatetime

    int

    float

    datetime

    money

    smalldatetime

    I need to creat this in one package if possible.

    It would help me a lot to know what would be the best data types (i.e. DT_I4, DT_NUMERIC, DT_STR, etc.) to map from the files to the data types in the sql table listed above.

    thanks for your help

    Al

  • Al,

    You may find better results posting in the SSIS forum, rather than SQL server 2008 newbies. You'll get more SSIS talent finding your post and answering.

    Jim Murphy
    http://www.sqlwatchmen.com
    @SQLMurph

  • Gosh, this one sounds a whole lot like homework, a test, or an interview question. 😉

    --Jeff Moden


    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.


    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply