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 11:46 am

    #939093

    Ed (2/5/2009)

    As G squared indicated, there is a UseDirectoryIfExists property you can set to True in the FileSystem Task. As to why your code isn't working - two things you might look into:

    1 - Variable Scope - can the task see it?

    2 - Is it designated ReadWrite on the script dialog?

    I clipped your code and ran it sucessfully, so there must be something in the setup.

    In regards to #2, how do I designate ReadWrite on the script dialog? Currently it's blank for ReadOnlyVariables and ReadWriteVariables. What should it be for these two?