Post reply

Data Insert from Excell File

  • January 23, 2008 at 12:27 am

    #76880

    Hi ,

    I have a Excell file which is having a data from various region ,i want to inset those data into a centralized database table ,Ecell and Table Structures are same.

    i want to achive task like folllowing criteria,

    there is a primary key in table structrue that is orderID (column name)

    if there is a primary key violation ,our dts process wont get stop,

    this will intimate or write a log file in a drive.with out terminating this process.

    how to achive this.

    datas are comming in the different rigon with same order or diffrent order .

    Please help me

  • January 28, 2008 at 8:17 pm

    #772716

    Can you give me an example of the data in Excel and also the table you want to create?

    What kind of problem do you have?

  • January 29, 2008 at 5:11 am

    #772791

    Why not import the data to a staging table, then load what doesn't exist (no primary key violation). If there are duplicates, load those to a separate table, and finally write to a log file.

  • January 29, 2008 at 5:46 am

    #772799

    If you have any option to use SSIS (SQL 2K5) instead, you can automatically reroute dups to a text file or even just ignore them. A nice improvement I've used to ignore the dups in Excel files I import.

  • January 29, 2008 at 10:28 pm

    #773116

    Thanks for your reply

Viewing 5 posts - 1 through 4 (of 4 total)

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