OLE DB Destination = temp table

Is it possible to write a dtsx so that the destination of an "OLE DB
Destination" Data Flow Destination is a temp table that is created earlier
in the dtsx ?On Mar 13, 7:05 pm, "John Grandy" <johnagrandy-at-gmail-dot-com>
wrote:
> Is it possible to write a dtsx so that the destination of an "OLE DB
> Destination" Data Flow Destination is a temp table that is created earlier
> in the dtsx ?
You may want to repost on the DTS/SSIS message groups. They are:
microsoft.public.sqlserver.dts and
microsoft.public.sqlserver.integrationsvcs. Sorry I could not be of
greater assistance.
Regards,
Enrique Martinez
Sr. SQL Server Developer

Old FSO snippet of code

Hi everyone,

Does anyone has ever written VbScript .Net stuff which do anything like that? I've got a dtsx package and I'd need covering along folder looking for subfolders and so on

objFSO = CreateObject("Scripting.FileSystemObject")

objFolder = objFSO.GetFolder("c:\test")

colSubfolders = objFolder.Subfolders

For Each objsubfolder In colSubfolders

...

...

Thanks in advance and best regards,

System.IO.FileSystemInfo is what you need

http://msdn2.microsoft.com/en-us/library/system.io.filesysteminfo.aspx

-Jamie

|||The .NET Version of this would be.

Dim Directories As String() = System.IO.Directory.GetDirectories("C:\test")
Dim I As Int32
For i = 0 To Directories.Length - 1
Dim TmpInfo As New System.IO.DirectoryInfo(Directories(i))
TmpInfo.Delete(...
Next

Links embedded in code go to documentation for related classes. Please see them and look at the "methods" list for a complete list of method's available to you.
Hope this helps,.|||Tons of thanks Jamie and MarcD.