staging database, where I want to run stored procedures on them. The
stored procedure part I can handle just fine. But I can't find a great
way to tell SQL Server to import all .TXT and .CSV files in a single
pass (or maybe 2 passes, one for each extension). These are all comma-
or tab-delimited text files. I'm running SQL Server 2000. Anyone know
a way to import several files at once? Anyone know the command I can
use for each file, which I can use by replacing the filename as
appropriate? Basically, I'm hoping someone knows a command something
like:
execute ImportTextFile [c:\blah\*.csv] /option1 /option2 blah blah blah
or
while @@fetch_status = 0
begin
execute ImportTextFile [FilePathHere] /option1 /option2 blah blah blah
fetch ...
end
Thanks!
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]
