SSIS Tutorial Part 28-Archive Files with Datetime after Loading into SQL Server Table

[@thandotshijila9703]

It's 2024 and this video is still helpful!🙏

[@balajiabhi9039]

Thanks is a small word of gratitude sir which won't be sufficient to wish you. However thanks a million sir!!!

[@TechBrothersIT]

So nice of you. Thank you so very much for kind words. Good luck with learning.

[@billg.7139]

Best 'How To' Video on KZbin!!!!

[@DenatBalla]

Still super useful in 2022. Thank you!

[@laurenhammer2350]

Thank you! This worked perfectly the very first time after following your steps. Great video!

[@FabricioMachado]

Very good! Is 2020 and your video still save lives heuehueheueheue Thanks!

[@pushpa_coder]

Hello. I have a small doubt. at @8:10, Since we already are using foreachloop container to iterate the process of going through file names, why do we need to configure the expression in property of the FlatFIle connection manager? Thanks for your help in advance!

[@Loves-f3y]

For the variables created within the Foreach Loop Container the scope is the Foreach Loop Container?

[@chetmon]

Thank you!!!! This tutorial helps a lot.. You're a blessing

[@TechBrothersIT]

You're very welcome!

[@sischero]

This video is very helpful. I figure it out by your help. Thanks a million. Keep up the good work. And also I just wanted to add a comment that removing the semicolon from the name of the full path is not an option, it should be removed or replaced otherwise SSIS throws an error.

[@edreimpanduki1139]

Thank you for this video, very concise and easy to follow

[@TechBrothersIT]

You are very welcome. Thanks for the support and liking our effort.

[@aakashr2300]

@@TechBrothersIT But at last there is nothing in input folder right but it ill cause an error right while next time executon of package right , either file is not found at c drive or you don't have access to the path can you suggest how to fix this issue

[@jen4770]

Thank you so much to find the error. I tried it and it works. Thank you to post and share such a wonderful tutorial.

[@TechBrothersIT]

+Jinyuan Xu Glad to hear that it solved the issue. You are welcome and thanks for kind words!

[@Oxx76]

Just wanted to say thank you. Helped a great deal. Cheers! :)

[@darrylw99]

Can you redo and add an error output so we can get error message, filename, field please

[@mrhoangvo]

How do you execute FileSystemTask upon "success" of multiple DFTs? Individually it worked but when added more than 1 source, it did nothing.

[@rahulgautam511]

Thanks in advance. I have created two packages similar to this video, which means I took the similar source folder and archive folder in both cases. But when I run the packages, they throw an error "the process cannot access the file because it is being used by another program" in both cases. When I changed the folder paths, packages run perfectly fine. Could you please advise why this is happening? Does it mean we can't have the same paths?

[@Tulluruupendar]

Thank you for the video.It is very helpful and Instructions are excellent

[@connectdeba]

Hi Ameer , can you please explain if you need to perform a validation check before actually do the dataflow task , how would you do that. For example if you check if the file name consists certain naming format , then how the flow would have changed.

[@5kpwc14]

Good tuto , have any idea how to imported file.shp geographic data?

[@EIStudent]

Worked like a charm! Thanks you!

[@amarnadhgunakala2901]

you just renamed file in file system task but howcome its moved actually ?

[@sarveshnundram866]

hello what if the file contain a date for example test_20210401.txt - we load it ok and tomorrow the file comes in again with test_20210402.txt ? where can I change it to take it dynamic?

[@TechBrothersIT]

You will use foreach loop and you don't have to provide any date in that, you will only read files from folder and they will be read automatically with different names.

[@maxmeista]

For some reason, I get an error after the first file gets loaded and archived... It seems as if it's looking for the same file in the Input_File and that it can't switch to the others that are present. Any suggestions? =)

[@sqldbasaga337]

Very Helpful video.. Thank you So much!!

[@TechBrothersIT]

Glad it was helpful!

[@zx-25r12]

Thank you so much, veri informative video and easy to follow.

[@pearldatasolutions3782]

Your videos and instructions are excellent. Can you please slow down in the future. It requires that I pause and back up time and time again

[@TechBrothersIT]

+PearlDataSolutions Hi, will do our best:) Thanks for watching!

[@parimal2267]

hi just have one question is it possible to have single ssis package for three different source file of text format to convert to other format using configuration or something else . I am able to process in 3 different packages in one solution but client is asking to have single package for all how ???

[@TechBrothersIT]

Hi, sure you can have single ssis package for multiple files. The config you are using for each can be put in one.

[@krishnachaitanya3346]

how to download excel files from sharepoint web application folder and archive the same sharepoint URL starts with ?

[@aakashr2300]

Can you make a video for moving a single file to the archieve folder please I need the video can you make it

[@syedrahaman4005]

How will get all your videos together ?

[@TechBrothersIT]

They all are online, If you want to follow them by course, I will suggest you to go to www.techbrothersit.com and follow by course.

[@jhungyi]

Thank you for the excellent videos.

[@TechBrothersIT]

Hi Justin, Thanks for kind words, glad to hear that you liked my effort. Thanks for watching and leaving comments.

[@supamanFTM]

Helped alot.. thank you!!

[@saibomma3758]

For me I Am getting [File System Task] Error: An error occurred with the following error message: "The given path's format is not supported.". i Did exactly what in video. but i am getting this error can any one please help me

[@Funlikalibra]

Your video is great I followed it step by step although I am using an excel source. I have a slight problem the package stops after only one file is uploaded into SQL and moved over to the archive folder. Do you have any idea on why this may be happening? Thanks in advance.

[@TechBrothersIT]

Hi Billye, So your all excel files has one sheet? or One file has multiple sheets you are trying to load? Do you have all the files with same extension, Maybe you are reading only .xls files and there are some files which are new with extension .xlsx and in your foreach loop you have specified extension only for .xls.

[@Funlikalibra]

Tech Brothers Thanks for the quick response. I am loading multiple files with one sheet. I used the wildcard to make sure the files are picked up with similar names. This is what I use "prospect*.xls*" Before I was tasked to append the date to the files once archived the files all uploaded and moved over seamlessly. With the move file selected but now the error code I am getting is saying [SSIS.Pipeline] Error: "Prospect_B" failed validation and returned validation status "VS_ISBROKEN". When I look in SQL Prospect_B is uploaded and the folder is archived. The package stops there.

[@TechBrothersIT]

Billye Jackson You might forgot to set Delay Validation property true. It might try to validate the connection and expression are not true at pre validation.

[@Funlikalibra]

I have it set it to true. Any other suggestions. What should the filename variable be?

[@TechBrothersIT]

Billye Jackson that will be the name of file which will be extracted from folder. I will create a video how to load and archive Excel files, will try to do it this week.

[@chavatdon]

gives me error on file system task. variable is used as a source or destination and is empty. i also set delayvalidation to true still its not working

[@TechBrothersIT]

Ho Aseem, provide any values to variable such as test. I remember getting this error if u leave the variable without value. The vale will be overwritten when we will execute ssis package. Thanks.

[@chavatdon]

I did set FileName as test.txt . it still gives me an error

[@chavatdon]

Tech Brothers When i gave a test value to inputFullPath and FullArchivePath it worked. but it doesnt move files to my destination folder yet

[@TechBrothersIT]

You need to provide text value to only FileName variable. Rest of variables should have your folder path, FullArchive path variable also does not need to have any value as it will constructed by using Expressions. Watch video one more time and give a try. Stop the video and configure step by step. It should work fine.

[@chavatdon]

Tech Brothers Yay !!! the error was inputFullPath and FullArchivePath properties were not set to be evaluated as expression. so I changed evaluate as expression for both of them to true.. and it worked

[@youthcollections23]

Exactly i did follow these steps even also i am getting some errrors like "[File System Task] Error: An error occurred with the following error message: "The given path's format is not supported.". Task Archive the file after loading failed".Can any one explain me what we have to do?

[@alaeddin1414]

dude ... THANK YOU for this video

[@TechBrothersIT]

Alaeddin A.D.B You are welcome!

[@alexandersimbolon3617]

Thank you, Great video !

[@senithhashika8751]

Very great and usefull video

[@shovabaral2797]

Please show how I can move excel files ❤

[@parimal2267]

only the location is different for them where file is to be taken out and where file is to be move

[@TechBrothersIT]

Got you. You will need six variables or six parameters to save you configuration for 3 input and 3 output folders.

[@cheis509]

Very helpful.....Thank you

[@TechBrothersIT]

You are welcome, thanks for watching.

[@Abhishekkumar-uy6he]

Thanks you for the video :)

[@narkall]

Thanks a lot it's very usefull !!

[@TechBrothersIT]

+Dim You are welcome and thanks for watching!

[@jen4770]

Very good education Video. Thank you so much. I follow your example and create SSIS package. I get an error of [File System Task] Error: an error occurred with the following error message: " could not find file 'C:\Windows\System32\PTI_daily20150920.txt. TXT' " .

[@TechBrothersIT]

Hi. Looks like you have written wrong expressions. You have extension twice. Remove the .txt from expressions and try.

[@saurabhagrawal8460]

very nice..

[@georgigeorgiev4871]

Dude, it is a good video. But please define at the beginning what archiving means for you. If it is simply copying to another folder, you could've specified this in the title...

[@VelevGeorgi]

well ..it is a good tutorial

[@TechBrothersIT]

Thanks Georgi. Glad you liked it!!

[@vipexecsuite8350]

Very good tutorial. Thank you!