Unable to load CSV file into sql server table.

• saidwarak01

  SSCommitted

  Points: 1577

  More actions

  September 16, 2009 at 11:42 am

  #135932

  Hi everyone,

  I have a CSV file with 10000 records and when I am trying to load this CSV file into sql server table I am unable to populate these records into sql server table on QA server but I am able to do it on DEV Server. The file remains same for all the environments. The surprising part is when I copied and pasted the record which created problem at the end of the last record of the CSV file. The package got executed successfully on QA Server.

  Please let me know if anyone has prior experience like this and please let me know what could be problem.

  This process needs to be automated and there will be no manual intervention.

  Thanks in advance.

  Thanks,

  sai

• Phil Parkin

  SSC Guru

  Points: 246979

  More actions

  September 16, 2009 at 12:16 pm

  #1054657

  This is somewhat similar to telling someone that your car is not working and asking whether anyone knows how to fix it.

  Please provide more details, error messages etc, so that people have at least a fighting chance of giving you something useful.

  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