Post reply

Text File Import for SS2K5 HELP PLEASE

  • May 21, 2009 at 11:36 pm

    #204485

    I am stuck. I have a deadline NOON May 22. I need to setup a stored procedure to import the attached text file into a table. This will be done daily.

    I am getting errors and really need a hand. Would someone be able to write something that I can use for the import?

    <hr noshade size=1 width=250 color=#BBC8E5> Regards,Jeffery Williams http://www.linkedin.com/in/jwilliamsoh

  • May 22, 2009 at 1:36 am

    #998710

    Instead of a stored procedure are you able to create an import task via the import wizard and then save the package it creates and reuse it in a job?

  • May 22, 2009 at 6:14 am

    #998812

    try doing it using bulk insert with , as field terminator

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

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