Post reply

Unable to load CSV file into sql server table.

  • 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

  • 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.

    If you haven't even tried to resolve your issue, please don't expect the hard-working volunteers here to waste their time providing links to answers which you could easily have found yourself.

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

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