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

Popular posts from this blog

html - Outlook 2010 Anchor (url/address/link) -

javascript - Why does running this loop 9 times take 100x longer than running it 8 times? -

Getting gateway time-out Rails app with Nginx + Puma running on Digital Ocean -