Home SSIS Archiving a file
Reply: 0

SSIS Archiving a file

user619
1#
user619 Published in April 25, 2018, 12:35 pm

I have an SSIS package that outputs a csv file what I want to do is look in the destination folder before I generate a csv and if one already exists (I produce them on a daily basis ) then move it to an archive folder.

my file name structure is "NAME_YYMMDD_HHMM.csv" I'm not sure how I go about looking for a file as the date and time will always be different. i've created a variable for the filename "NAME_*_.csv but not sure how id add this to a file system task? if a file doesn't exist id like it to just move on to next step in package if it does exist then move file to archive folder

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.578555 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO