• So are you trying to rename the file in a folder, or change the source filename for a connection?

    To change the filename in a folder, there isn't a file rename method so just use the MoveFile method to do the rename.

    For for the source filename, you'll need to create an object that refers to the connection you want to change and then assign your new filename to the appropriate property. Check http://www.sqldts.com for example of how to do this.

     

    --------------------
    Colt 45 - the original point and click interface