File System Task failing to move ZIP files in SSIS 2005 -
before start: yes, have use 2005. no, can't upgrade, it's not decision.
i have ssis package suppsed perform following tasks: 1. zip text file using 7-zip 2. ftp file specified site 3. move zipped file archive folder
steps 1 , 2 work fine, when comes time move folder fails. error message says, "could not find part of path '\shares2\clntrial\datamgt\c1460\datatransfer\data\sent\txt\archive\abc701_xxx_2015-09-30.zip\abc701_xxx_2015-09-30.zip'." can see, has zip file name in path twice.
that file destination path set connection manager connection string populated expression uses variables. when edit expression, evaluates correct path file name appearing once, is, "\shares2\clntrial\datamgt\c1460\datatransfer\data\sent\txt\archive\abc701_xxx_2015-09-30.zip".
why ssis adding file name second time when package runs?
never mind, i'm idiot. including zip file name "abc701_xxx_2015-09-30.zip" in destination i'm telling file system task consider target folder. duh.
Comments
Post a Comment