Home Forums SQL Server 2005 SQL Server 2005 Integration Services Using Script Task to check if Folder Exists RE: Using Script Task to check if Folder Exists

  • February 5, 2009 at 12:34 pm

    #939126

    Ed (2/5/2009)

    Here are example values for the FileSystem task:

    UseDirectoryIfExists = True

    Operation = CreateDirectory

    IsSourcePathVariable = True

    SourceVariable = User::DirToCreate

    For your script dialog:

    ReadWriteVariables = FolderExists

    Thanks Ed for the ReadWriteVariables, the Script Task now executes.

    As far as the FileSystem task for Creating the directory, I would like to keep my settings as is because it works with the dynamic variable i'm using to create the folder. Here's what I have

    UseDirectoryIfExists = True

    Operation = CreateDirectory

    IsSourcePathVariable = False

    SourceConnectoin = test (this is the test folder + plus the dynamic variable which will be the date, so in the end it will be E:\test\01-15-2009

    Can I use something in the Expression to disable this FileSystem if the folder exists? I used this in the Expression of the file system and it error out so I'm not sure if I'm using the correct Property:

    Property = Disable

    Expression = @[User::FolderExists] ==true