question

sajal01552 avatar image
sajal01552 asked

How to search folder in the file system and move it to the destination file system using ssis?

I have some tables in SQL Server database, in each table there is a column that contain a ID number. For some each specific ID number application create a folder in the file system, folder name is same as ID number, folder contain many sub-folder and files with different name. I have to select ID numbers from tables and need to find those ID number in file system as a folder name, if any found then move the folder and its all contains to the destination file system if the folder do not exist in the destination. I may need your help to do this using ssis.
sqlssissql-serverc#
3 comments
10 |1200

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

JohnM avatar image JohnM commented ·
Can you use Powershell to accomplish this? Might be easier.
0 Likes 0 ·
sajal01552 avatar image sajal01552 commented ·
No, I can't use Powershell, I have to use SSIS because I need to manipulate SQL Server database also.
0 Likes 0 ·
JohnM avatar image JohnM commented ·
You can do that in Powershell as well just an FYI.
0 Likes 0 ·

0 Answers

·

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.