sql server dts: inserting a file list into a SQL table -- sql server dts

Re: inserting a file list into a SQL table

jaylou
7/19/2006 1:44:01 PM

Thank you! That did it.

One thing use /B instead of /-C and there is no need for modification it
will only bring in file names.

Thanks again!
Joe

[quoted text, click to view]

Re: inserting a file list into a SQL table

Roy Harvey
7/19/2006 4:25:32 PM

create table #dir (line varchar(255) NULL)

INSERT #dir
exec master..xp_cmdshell 'dir "C:\WINDOWS" /-C'

select *
from #dir
where line IS NOT NULL
and line NOT LIKE '%<DIR>%'
and substring(line,1,1) <> ' '

Using SUBSTRING and CONVERT against #dir.line I leave to you.

Roy Harvey
Beacon Falls, CT

On Wed, 19 Jul 2006 12:26:01 -0700, jaylou
[quoted text, click to view]

Re: inserting a file list into a SQL table

Roy Harvey
7/19/2006 5:41:42 PM

On Wed, 19 Jul 2006 13:44:01 -0700, jaylou
[quoted text, click to view]

The original post indicated "I need a way to grab the files by name
and also by size" so I used a format that included the size. Certainly
of all you need is the name then /B is simpler by far.

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.