Create Folder If Non Existent I need to check if a folder exists and if it does not create it.  So if C:\CSV\red\ does not exist create, and so on.  I use this DDL - how can I create folder if not there?

Create Table bonniebell
(
   name varchar(max)
)

Insert Into bonniebell values ('red'), ('blue'), ('green')

Declare @foldername varchar(max), @fulldirname varchar(max)

Declare folder cursor for

  Select name
  from bonniebell
  order by name asc

  Open folder

  fetch next from folder into @foldername

  while @@fetch_status = 0
  Begin

    Set @fulldirname = "C:\CSV\"

    Set @fulldirname = @fulldirname + @folder

  Fetch Next from folder into @foldername

  END

Close folder

Deallocate folder
You can use the extended stored proc "xp_dirtree".  Store the results in a temp table and get the rowcount.  Zero = not exists.  

create table #Files(
subdirectory nvarchar(512),
depth int)

insert into #Files
exec xp_dirtree 'c:\windowsX'

select @@ROWCOUNT

drop table #Files