Home Forums SQL Server 2005 SQL Server 2005 Integration Services Data Import from CSV file RE: Data Import from CSV file

  • November 25, 2012 at 5:23 am

    #1562036

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    rhythm.varshney (11/25/2012)

    Phil Parkin (11/25/2012)

    So what is your question?

    I need to import the data into the table.The logic is If Type is MSAD then it should update MSAD column of table with userid and if type is PCG then it should update PCG column also there should not be duplicate entry for a uername i.e. for RamKumar ther should be only one entry. with both MSAD and PCG column values.

    I am not seeing a UserId column.

    Also, all you have done is stated your requirements. From these, you are assuming that I can guess what your question is, but I can't.

    UserId column is in CSV file not in SQL table.

    Ahh, I see - I saw 'User' and 'Id' separated by a space and assumed they were separate columns.

    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.