Post reply

automated package

  • December 8, 2007 at 8:38 am

    #377369

    Hi all,

    I have to create a automated package. Firstly i have to import 2 specific columns from a excel file to create table1 in a database. then i have table2 with 20 columns out of which i need only 3 columns. so its goes like this , i want to merge table1( 2 columns) with table 2 ( 3 specific columns) to create a new 3rd table with 5 columns. I want all these to automated.Here below is what my manager ask me to do for more clarification.

    The plan should be: Automated Import of Excel file to a table.Automated code as stored procedure which will compare another table to this imported table. Output results of the table are 5 columns.

    Eventually the code and automated import process will be implemented in a database.(Note: this sql server 2000 environment)

    Please i would appreciate if anyone can guide me to make this package .Thank u all

    Yukon DBA

  • December 8, 2007 at 12:54 pm

    #758314

    The following is your guide... the rest is dependent on your "Yukon DBA" knowledge of T-SQL 😉

    http://www.sql-server-helper.com/tips/read-import-excel-file-p03.aspx

    --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 2 posts - 1 through 1 (of 1 total)

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