Twice number of reows loading from sql table to Excel.

• abhas

  SSCarpal Tunnel

  Points: 4681

  More actions

  March 4, 2013 at 4:27 am

  #290471

  Hi,

  I am having sqltbl which contains empid,Lname,Fname,Sal records.

  I am simply fetch all records from table to excel using ssis.While execting package showing same number of rows inserted as in table but if i check it in excel then each record is inserted 2 times.

  eg. if in table there are 5 records then package execytes sucessfully and shws 5 rows but idf i check excel then it is showing 10 records.

  It is very urtgent pls helpppppppppppppp!!!!!!!!!11

  Thanks

  Abhas.

• Phil Parkin

  SSC Guru

  Points: 246977

  More actions

  March 4, 2013 at 4:34 am

  #1592950

  Are you sure that you haven't just run the package twice?

  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