question

ck3090 avatar image
ck3090 asked

move files with no duplicacy

i have created a package which copy file from one folder to another folder and saving the file name in DB table .Now i want to modify this package so that first it checks the file name against table entry and if found then it should not move that file and redirect to next file of source folder.Can any one please answer my question? Thanks in Advance
sql server 2012
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Dave_Green avatar image
Dave_Green answered
Assuming SSIS, this is certainly possible - with which bit are you having difficulties? You may want to look at conditional flows to help you achieve this sort of workflow - and think as to whether the package should log some message when it finds the file name existing in the table.
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.