Post reply

Import text file HELP

  • May 15, 2009 at 4:49 pm

    #137835

    I have a text file that seems to be a bit of a mess to me. There is no line end eliminator either.

    I need to create a sproc that will run as a job to import a file just like the sample attached each night.

    This will be a on SQL 2005 box.

    Any help would be great.

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

  • May 15, 2009 at 5:10 pm

    #995762

    Hi Jeffrey

    I'm no SSIS pro but your file looks like a usual CSV (except the trailing spaces). I just took your file, added a "Flat File Source" and specified:

    Format: Delimited

    Text Qualifier: "

    Row delimiter: CR/LF

    Column delimiter: ,

    Looks good in my package.

    Greets

    Flo

  • May 15, 2009 at 5:48 pm

    #995772

    Thank you sir.. I shall give it a try.. I was always very strong with complex T-SQL in 2000... Been out of the game for a little while and have not worked with 2005 a ton, now 2008 is here.. I need to get on the ball!

    J

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

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

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