I am kind of new to Sql Server 2005.
I figured out how to use the import data wizard to import a delimited text file.
But I need to find a way to import many delimited text files at once.
does anybody know if this can be done in Sql Server 2005? and how?
thanks in advance,Hi,
you should probably use integration services for that. SSIS has a special task for that which will loop though a directory and inmport all text files which fit into the filter specified before.
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment