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.
@@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
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!
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.
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?
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? =)
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 ???
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.
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.
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.
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.
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.
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?
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?
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.
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
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' " .
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...
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.
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.
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