Post reply

How to import lots of text files into table?

  • June 10, 2011 at 2:05 pm

    #1337256

    That's the kind of thing SSIS does really well at.

    It can query a folder for a list of files, or operate off of a query to a database table, and step through the files and do imports, data cleaning, error handling, etc.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

  • June 20, 2011 at 1:25 pm

    #1341420

    If SSIS is not a goer then bulk insert might do the job.

    http://msdn.microsoft.com/en-us/library/ms188365.aspx

    Hope this helps,

    Tom

    http://www.bluesmithis.com[/url%5D

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

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