Welcome to EMC Consulting Blogs

PingBack from http://dichotic.wordpress.com/2006/11/14/source-file-archiving-ssis-versus-datastage/

I used the sample as a template to check if a file exists in a location...

Try

           Dim SourcePath As String

           Dim SourceFile As String

           Dim FileProcessedCheck As String

           Dim FileProcessingCheck As String

           FileProcessingCheck = Dts.Variables("PaymentFileSoureDirectoryFile").Value.ToString

           SourcePath = Dts.Variables("PaymentFileTargetDirectory").Value.ToString

           SourceFile = Dts.Variables("PaymentFileName").Value.ToString

           FileProcessedCheck = SourcePath & "\" & SourceFile

           If File.Exists(FileProcessingCheck.ToString) Then

               'Check to see if file is being processed

               Dts.Events.FireInformation(411, "ScriptComp", "File" & SourceFile.ToString & " is processing", "", 114, False)

               Dts.TaskResult = Dts.Results.Failure

           Else

               'Check to see if file exists in Processed folder

               If File.Exists(FileProcessedCheck.ToString) Then

                   Dts.Events.FireInformation(411, "ScriptComp", "File" & SourceFile.ToString & " has already been processed", "", 114, False)

                   Dts.TaskResult = Dts.Results.Failure

               Else

                   Dts.Events.FireInformation(411, "ScriptComp", "Executing FTP task for " & SourceFile.ToString & "", "", 114, False)

                   Dts.TaskResult = Dts.Results.Success

               End If

           End If

       Catch ex As Exception

       End Try

well,

I just used "Rename fle" option and it does all the trick. It moves and changes the name  in one task.

Tomek is right.  No reinvention of the wheel necessary.

It's awfully unintuitive that the developers of SSIS wanted us to use "rename" for this purpose rather than "move", though.

is it same proceure to add date extension in OLE DB Destination. I am trying to create different staging table for every day but have not been able to change file name. For eg: tblProduct20060203, tblProduct20060604

I concur with Tomek,

The File System task does the trick without writing any custom code. The only issue is that you might have to check if the file actually exists before trying to archive/move it. That is probably why the code above was written.

I found a nice blog that shows how to deal with this. It can be found at the following URL:

http://dichotic.wordpress.com/2006/11/01/ssis-test-for-data-files-existence/

Ciao,

Colin

and how can i change just the filename but in the same folder???