ssis: Archiving files with VB.Net
When creating ssis packages it's a common requirement to be able to archive the processed files. Here's VB.Net code snippet, with a quick walkthrough, that does exactly that. The script uses two variables, inFiles and archiveFiles . The variable inFiles contains the folder we want to move files from, and archiveFiles is the destination. Configure your variables in BIDS like below. Add a script task to the designer. Right click the script task, choose 'Edit'
Blog Content
No comments:
Post a Comment