Error when using File system task to create dynamic directory in SSIS
Posted on 2014-11-14
Hi, I have a ssis package that includes creating a new directory based on file name of a file.
I am using a file system task. When I run the package everything works but I get the following error:
The connection '[new directory path here]" is not found. This error is thrown by Connections collection when the specific connection element is not found.
I have three variables;
strDestinationArchive: directory path that the new directory should be added to
strArchiveFolderDate: substring of the filename which will be the new directory name
strDestinationArchivefolder: strDestinationArchive + strArchiveFolderDate
In my File System Task properties I have my SourceVariable set to strDestinationArchivefolder
Then I have an Expression added for Destination = strDestinationArchivefolder
I'm not sure how to get rid of this error. Everything is working fine but this error is bugging me. Can someone help me out?