150 How to move files to month wise folders in ssis

[@krishnamurthy4036]

Hi Aquil, can you please do a video like how to protect package in ssis

[@learnssis]

Okay sure.

[@lakshmigv5223]

Which containers we can use to load data from files to sql db in real time?

[@learnssis]

Data flow task can load data from flat files to SQL server database.

[@learner_SSIS]

For each Loop container with file enumerator

[@Teja0709]

Hi I have a question I have 2022,2023,2024 year files in my source folder and I want to create a destination folders where 2022 files should go to 2022 folder,2023 files should go to 2023 folder and so on... so everyday i get 10 files at sourve filepath with different years. I need to check if destination filepath has a folder with that year. If we dont have then create a folder or else no. So how can I implement this in ssis. Do you have video on this? Can you help me

[@learnssis]

I don't have a video on this topic, but will try to make one. First we need to get the last modified date from a file, then from date get the year and assign it to an ssis variable. Now concatenate this year with the destination folder ssis variable to make up a complete folder path, and then you can use file system task to create a directory, and the use file system task to move the file to the detonation folder. Everything will happen inside a foreach loop container with file enumerator. I will try to make a video on this one.

[@Teja0709]

@@learnssis Thanks a lot!!

[@Teja0709]

@@learnssis So I am running with some issues Can you help me I followed your video on how to move files to month wise and implemented So I have assigned sourcefilepath to somefilename in source and then in foreach loop i had script task that will fetch filename from the sourcefilepath and year from the file name. Now I am having 2 file task one is to create directory with destination file path and year stored in ssis variable and other task is to copy the file from source to destination What I am facing issue is My ssis is working but it is just copying only one filename that I have mentioned in source filepath and just copying that in destination without creating the directory. Please help me why other files are not moved? Why source filepath is not changing during runtime? And why directory is not getting created? Example In ssis I have to copy files from source to destination based on year wise This is how I implemented I had Sourcefder as d\wirk\ source filepath containing D\wirk\ex.txt FIlename and year variables assigned as empty Destination folder D\woer\ Destination filepath is destinationfolder + year Having foreach loop container that has source folder in expressions and in variables mappings having sourcefilepath Now having script task that will read sourcefilepath And write variables destinationfilepath,filename and year Filename=get.filename(destinationfilepath) Year = filename.substring(0,4) Once these are updated here I am having a file task to create directory using destinationfilepath And one more filetask to copy files from sourcefilepath to destinationfilepath This is what i did But directory is not created

[@learnssis]

@@Teja0709 I am going to post a video on this topic today, I have the package ready, you just need to pass the sourcefolderpath and destfolderpath value to the ssis variable. if you can send me a hi message on [e-mail] then I can send you the package.

[@aniltechbro1233]

Hi sir we can do dynamically moving he files

[@learnssis]

Yes we can do that. Below is an example of moving all files from source folder to destination folder. kzbin.info/www/bejne/f5PMlnd3ltmZa68

[@prasadbandi1995]

how to stop foreach loop container? please make video on this

[@learnssis]

Sorry I did not get your question. For each loop container if you are using as File Enumerator then it will run for all files in a folder and then will stop automatically. if you are using foreach loop container for ADO enumerator then it will run for all records those you get in the Object variable in last step and then will stop automatically.

[@kichuchinnu3303]

Hiii sir , I have an issue in my stored procedure I want to show my stored procedure to you Is that possible to connect with you ?? please consider

[@naveenkumark6093]

❤❤

[@learnssis]

Thank you Naveen Kumar.

[@darbarshahi]

❤❤❤🧁

[@learnssis]

Thank you.

[@learner_SSIS]

Good sir 👍

[@learnssis]

Thank you so much.

[@learner_SSIS]

hi Aqil sir, copy file one server to another server SSIS package manually running but job sceduling failed, please make video sir

[@learnssis]

Have you deployed the SSIS package to SSIS catalog. If yes can you go ssis catalog then go to project, right click on it, go to reports, all executions, check the error message there and share the error details. The reason for the failure can be different in different scenarios, thus even if I make a video its not necessary that whatever error I will get you will get the same error the errors will be different thus we need to look at the current error and see the reason for its failure.