Post reply

Problem Importing CSV Files into SQL 2008 using SSIS

  • July 6, 2012 at 6:16 am

    #1509633

    I can't answer your question, it resolved the problem you described on the original post; now you got a working application, feed it with your data, try to break it, and fully understand its logic because you will be looking after it once deployed, you receive help in sites like this, but it will be unprofessional to avoid understanding the solution given.

    Did the sample of records you posted included records having embedded commas in its data?

    Did you try to load records having commas in its data with the solution given? what did it happen?

    Cheers,

    Hope this helps,
    Rock from VbCity

  • July 12, 2012 at 2:13 am

    #1511905

    Just out of interest can this be used with SQL 2005 SSIS packages?

  • July 12, 2012 at 8:43 am

    #1512115

    Hi Cuclasi,

    The whole idea should work in Sql 2005, the only drama is with the script code, It is written with C# and you need to convert it to Vb.Net as SSIS 2005 does not support C#.

    Cheers,

    Hope this helps,
    Rock from VbCity

Viewing 3 posts - 16 through 17 (of 17 total)

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