I've set up a File System Task to move a file. I set IsDestinationPathVariable to True. When I click inside the DestinationVariable value column and either click the drop-down arrow or hit the up/down arrow keys on my keyboard, the File System Task Editor window closes immediately. In the same task, I have also set IsSourcePathVariable to True and am able to select SourceVariable without an issue. If I set IsDestinationPathVariable to False, the DestinationConnection drop-down appears to work fine. I've tried restarting Visual Studio, but it had no effect.
- Moved by Janet YeildingMicrosoft employee Tuesday, May 29, 2012 11:46 PM (From:SQL Server Data Tools)
I have tried to use File System Task on my Business Intelligence Development Studio, and all seems ok. Please try to drag another File System Task to the control flow and see if it has the same issue. If so, plese try to repair install the Business Intelligence Development Studio.
- Proposed as answer by Simon Lv Friday, June 01, 2012 7:54 AM
I have this same problem and have tried several alternative ways (like using Expressions to define the Destination) to work around this to no avail. Well, using an expression does help in defining the destination, but still it cannot find the destination defined via Expression. It appears like there is something broken in the DestinationVariable drop-down, or my package file is somehow corrupted.
Defining the source using the drop-down menu works ok, only the DestinationVariable causes the problems.