Very helpful to me.. Easy to understand step by step.. At starting i was not sure about it but once i completed watching this video i can make the project. Thanks please share more project related videos.
Very helpful and clear..one thing I would like to tell you when you are explaining it seems very easy but when I try to practice then it looks complex.. Thanks for sharing.. Please upload more projects related videos..
Current my project under SSIS , Too much complexity is there Load to staging Staging to foundation, Foundation to Band , I'm getting so much confused After saw your videos, I get know where I'm mistaken Thankyou sir
sir ..i have been following your videos from the starting video..i cant thankyou enough,,can you please do a video on how to exctract the data from table in sql server and load into that backup file .
Thank you for the detailed explanation. I have one question here please help me understand that scenario. As we used variables to make the process dynamic, is there any way where we give the variable values from parameter file. Lets say my file name changes in future i don't have to go package to make changes i can do changes in my parameter file containing variables and their values. Thank You in advance !
Yes you can use SSIS package configuration. Will record videos on configuration because I got many requests. Second we can also use a table in backend where you will have 2 columns first parameter names and second value and we can that table in package for setting parameters values.. Thanks-SS Unitech
Thanks Great tutorial! I made zip task with WinRaR executable. Every time I open Zipped file, it forces me to click all folders through file path. like C folder open Desktop folder double click destination double click. What i want is to see immediately the csv file when i open the archived file!
One humble request Shushil Bhai, Could you please make video where we can see real project explanation like for interview purpose.. With example of Insurance or Banking domain... which relate data warehouse concepts like(data mart,ODS and staging area and data cleansing, tables like dimensions and Fact tables ,Schema : star and snowflake)
Really appreciate your work. Nice explanation. For the same problem, I created dynamic source(flat)and dynamic destination(flat) and I was not able to load the data into destination folder except first file it self? Can you please guide me how to achieve dynamic connection for both flat file source and flat file destination?
Hi Sudheer, Thanks for your comment. As I said in video if you guys need more videos like this do comment. I got only 2-3 comments. But I will record more project related videos soon Thanks-SS Unitech
If anyone is having trouble with the Argument Expression for the Execute Process Task Editor here is the code that worked for me. Note if you add a period before "zip" then the file name will have two periods so i took that out from the formula: "a" + " \"-t7z\"" +" \""+ @[User::FolderPathDestination] + left(@[User::FileNameNew],len( @[User::FileNameNew] )-3)+"zip\""+ " \""+ @[User::FolderPathDestination]+ @[User::FileNameNew]+"\""
Hi Sir, can you please explain how to execute for all files in a folder, since you explained only one file is loading,moving and zipping know. How about all files to do the same ?? Thank you!
Hi Sir, Iam getting this error. Please assist [Execute Process Task] Error: In Executing "C:\Program Files\7-Zip\7z.exe" "a"-t7z" "D:\Projects\SSIS-Real time scenarios\Archieve\FF_CD_DerivedCol_2024_10_28.zip" "D:\Projects\SSIS-Real time scenarios\Archieve\FF_CD_DerivedCol_2024_10_28.txt"" at "", The process exit code was "7" while the expected was "0".
Hi Tarun, I would recommend to learn functions, stored procedure, and writing queries.. Thanks for watching video and comment. Keep watching and please share to others. Thanks-SS Unitech
I got through the first execution successfully, but then my Data Flow failed at the Flat File Source because it couldn't find the name after the name updated to include the date at the end. Not sure what I did wrong. "Flat File Source failed the pre-execute phase and returned error code 0xC020200E."
If anyone else gets this issue I figured out how to fix it although I still think there might be something incorrect, but not sure. Basically I just renamed the source file back to it's original name, and then when I executed the full control flow the data flow executed successfully and the file was renamed and also moved from the source folder to the archive folder. Edit: Oh I see at the end of the execution after he finishes degugging he "Disables" the File System Tasks. 1. Right click File system task 2. Click 'Disable' This enables the flow to continue without having to delete your previous work.
Sir, can u please tell me how to load files(different files are there in that one file is rename,, so i want to load that rename file also)using ssis package...
You can use foreach loop containers to loop thru all the files. I have already uploaded video on foreach loop container in SSIS tutorial playlist. Please check that
Hello Sir, Can you please make video On etl topic. Next week I have an interview..:( Even though I am searching but I haven't found it ETL related resources...Actually studying all the time from your channel..
i don't have 7zip files ..i am not able to create zip the file as i don't know what is 7zip file and how to use it ..please send that file ..i cant use excute process task successfully..thank you in advance.
I have explained how to load data into SQL server from flat files in SSIS tutorial part 3 (link available in description of this video). Can please let me know what sql concept I didn't explain? Thanks-SS Unitech
Hi sir..you are uploading nice videos. i am facing an issue "the process exit code was while the expected was 0" while executing the the execute process task from .txt file to .zip file.. how can we fix the issue?
![ETL Process using SSIS [Real Time Practical Example] Step By Step](http://i.ytimg.com/vi/ji2rigGiWis/mqdefault.jpg)
Tum bahot mast kaam krta hai Maqsood Bhai 👍 #ssunitech
Thanks Bhai, but my name is Susheel Singh
Very helpful to me..
Easy to understand step by step..
At starting i was not sure about it but once i completed watching this video i can make the project.
Thanks please share more project related videos.
Thanks Roshani for your appreciation..
Please share to others
One of the best video for checking your skill. Nice and easy to explain in interviews
Thanks dear,
Please share to others
Very helpful and clear..one thing I would like to tell you when you are explaining it seems very easy but when I try to practice then it looks complex..
Thanks for sharing..
Please upload more projects related videos..
Thanks dear..
Do practice it looks easy for you as well.
Thanks keep watching videos
What a video..it seems very easy and very helpful to explain in interview..
Really waiting for this video..
Thanks for uploading
Thanks Vaibhav
That's great effort Sunil garu 👍👍👍
Thanks 👍
My name is Susheel not sunil 😜
@@ssunitech6890 that's my mistake
I want full SQL videos sir
Please check in channel
It was very helpful for me thanks a lot 🙏
Thanks for your appreciation.
Please share to others
Current my project under SSIS ,
Too much complexity is there
Load to staging
Staging to foundation,
Foundation to Band ,
I'm getting so much confused
After saw your videos, I get know where I'm mistaken
Thankyou sir
Glad to know it helped
sir ..i have been following your videos from the starting video..i cant thankyou enough,,can you please do a video on how to exctract the data from table in sql server and load into that backup file .
Thanks for your appreciation 🙂
Already recorded video on the same
Please check in SSIS tutorial playlist
Hi Sushil. These videos are very useful for us.please upload more real time projects on SSIS for practice purpose
Thanks for your appreciation.
I have already uploaded few of videos.
ua-cam.com/play/PLNRxk1s77zfjbCU-BgnER0hrnf4TvY5A3.html
Very well explained brother. Keep it up and please keep on posting such project videos. We are waiting for them.
Thanks in Advance:):)
Thanks Lakshay..
Sure will upload move video for the same
awesome video n thanks, please share link of part 2.
Thanks.
Didn't upload part 2. I didn't get many requests that's what didn't recorded. But will do.
@@ssunitech6890 ohhh, btw thanks once again..
Thank you for the detailed explanation. I have one question here please help me understand that scenario. As we used variables to make the process dynamic, is there any way where we give the variable values from parameter file. Lets say my file name changes in future i don't have to go package to make changes i can do changes in my parameter file containing variables and their values.
Thank You in advance !
Yes you can use SSIS package configuration. Will record videos on configuration because I got many requests.
Second we can also use a table in backend where you will have 2 columns first parameter names and second value and we can that table in package for setting parameters values..
Thanks-SS Unitech
@@ssunitech6890 thanku . please upload videos soon. :-)
very useful for us.please upload the project on SSRS for practice purpose.
Thanks Shaik.
Please share to others
Super video
Thanks ☺️
Thanks Great tutorial!
I made zip task with WinRaR executable. Every time I open Zipped file, it forces me to click all folders through file path. like C folder open Desktop folder double click destination double click. What i want is to see immediately the csv file when i open the archived file!
Thanks a lot.
In my case it's happening.
You can use the same way that i did.
Thanks
Thank you so much Sushil🙏
Thanks Nita
One humble request Shushil Bhai, Could you please make video where we can see real project explanation like for interview purpose.. With example of Insurance or Banking domain... which relate data warehouse concepts like(data mart,ODS and staging area and data cleansing, tables like dimensions and Fact tables ,Schema : star and snowflake)
Sure will do brother.
@@ssunitech6890 thank you.. Bro..
Hi sir, for renaming zip files we have to download 7zip (or) default it will have in windows?
We have to download 7zip.
Hi,if big data then can we use direct query rather than create project in SSIS,SSAS
That will not work, you have to include any etl tool.
Really appreciate your work. Nice explanation. For the same problem, I created dynamic source(flat)and dynamic destination(flat) and I was not able to load the data into destination folder except first file it self? Can you please guide me how to achieve dynamic connection for both flat file source and flat file destination?
It should work.. Call me +919971652428 if you are unable to do this
Wow that's really great response brother.. Kuddos.. Definitely will reach out to you. Once again thank you so much.
Any time bro
Can you please explain this to me as well through my e-mail humafirdaus1014@gmail.com
This is very helpful, are there any continuation videos or any other more case studies
Hi Sudheer,
Thanks for your comment.
As I said in video if you guys need more videos like this do comment.
I got only 2-3 comments.
But I will record more project related videos soon
Thanks-SS Unitech
Hi Sir ji, Please provide Azure and Azur Data Factory real time project also.
Sure Thanks
If anyone is having trouble with the Argument Expression for the Execute Process Task Editor here is the code that worked for me. Note if you add a period before "zip" then the file name will have two periods so i took that out from the formula:
"a" + " \"-t7z\"" +" \""+ @[User::FolderPathDestination] + left(@[User::FileNameNew],len( @[User::FileNameNew] )-3)+"zip\""+ " \""+ @[User::FolderPathDestination]+ @[User::FileNameNew]+"\""
Thanks 👍
hi sushi,
this video was very good.how would u loop thru files for archiving all the files
Check in next projects
nyc explanation, i have one question.how to load data from client tostaging table and staging table to transactional table
Thanks.
We will be having 3 databases,
1. Testing
2. Staging
3. Main database
could you give me more info , what are benefits i got in case im taking you subscription ???
Will share the source files
Like this SSIS can you explain any power bi project to explain in interview
Thanks.. Please check i have uploaded more than 10 videos..
Appreciate your videos, can I expect SSAS real time videos from your channel, please
Will upload videos on SSAS after Power BI.
Thanks for your appreciations
Hi Mr Sushil, where can I get the source data and SSIS solution file that you showed in this video
Please check the description of the video
I have added source data in zil file
Can you please make a video in completely like dev qa and pord
Sure..
Hi sir, for moving All files dynamically, can we use for each loop container?
Yes we can
Hi Sir, can you please explain how to execute for all files in a folder, since you explained only one file is loading,moving and zipping know. How about all files to do the same ?? Thank you!
Watch this video to understand about loading data from multiple files
ua-cam.com/video/Eqglee18K_s/v-deo.html
Hi,Do you have any other projects for SSIS?
No we don't have any other projects at yet.
We need more projects
Sure.
I am working on a project once done I will record and upload for sure.
Thanks
If we have 5 files then we need to do like this for all then???
Use one for each loop, and perform all these steps under for each.
Hi Sir,
Iam getting this error. Please assist
[Execute Process Task] Error: In Executing "C:\Program Files\7-Zip\7z.exe" "a"-t7z" "D:\Projects\SSIS-Real time scenarios\Archieve\FF_CD_DerivedCol_2024_10_28.zip" "D:\Projects\SSIS-Real time scenarios\Archieve\FF_CD_DerivedCol_2024_10_28.txt"" at "", The process exit code was "7" while the expected was "0".
Sunil I'm trying to join membership , but join button automatically shown purchase cancel I don't know why
Don't know why it's happening
please do the same video using for loop
Did u check SSIS tutorial playlist??
I have already uploaded videos on looping.
Can you show the DB to json file with specific name and date and unique I'd also
Will record a video on the same.
Tq sir.... and I need small help from u sir... what are the SQL concepts are required for msbi sir
Hi Tarun,
I would recommend to learn functions, stored procedure, and writing queries..
Thanks for watching video and comment.
Keep watching and please share to others.
Thanks-SS Unitech
@@ssunitech6890 tq so much sir
I got through the first execution successfully, but then my Data Flow failed at the Flat File Source because it couldn't find the name after the name updated to include the date at the end. Not sure what I did wrong.
"Flat File Source failed the pre-execute phase and returned error code 0xC020200E."
If anyone else gets this issue I figured out how to fix it although I still think there might be something incorrect, but not sure. Basically I just renamed the source file back to it's original name, and then when I executed the full control flow the data flow executed successfully and the file was renamed and also moved from the source folder to the archive folder.
Edit: Oh I see at the end of the execution after he finishes degugging he "Disables" the File System Tasks.
1. Right click File system task
2. Click 'Disable'
This enables the flow to continue without having to delete your previous work.
Thanks 🙏
This proces only .TXT files or any files. In same process?
Yes it's designed for flat files.
You can change the source as you want.
Thanks
SIR, move file task and rename file task can be done in 1 file system task!
Yes we can do this.
Thanks
Sir, can u please tell me how to load files(different files are there in that one file is rename,, so i want to load that rename file also)using ssis package...
You can use foreach loop containers to loop thru all the files.
I have already uploaded video on foreach loop container in SSIS tutorial playlist.
Please check that
What is the advantage of joining tge chamnel ?
Many advantages you can get all the source files free for practice.
Hi. It's not zip the file. showing error The process exit code was "7" while the expected was "0". Could you please help me.
Don't know, but i opened it's working
Hello Sir, Can you please make video On etl topic. Next week I have an interview..:( Even though I am searching but I haven't found it ETL related resources...Actually studying all the time from your channel..
Sure.
I have already uploaded 70+ videos on SSIS. Will try to do interview questions and answers
Hi bro ,I did same process but error this " could not find a part of the path " how to solve please ?
The path will not be in your system.
I am unable to se connections String in property expressions
i don't have 7zip files ..i am not able to create zip the file as i don't know what is 7zip file and how to use it ..please send that file ..i cant use excute process task successfully..thank you in advance.
You can download the 7zip and then test it
Very useful but data load to data warehouse not explain and also SQL concept not explain
I have explained how to load data into SQL server from flat files in SSIS tutorial part 3 (link available in description of this video).
Can please let me know what sql concept I didn't explain?
Thanks-SS Unitech
Data load flats file to SQL server I know but project point of view data load fact and dimensions table.
Ok will upload..
You made dynamic connection but u didnt explain by changing file name..
I explained in second part of the video. As you can see I used filenamenew variable for renaming file.
@@ssunitech6890 have u uploaded 2nd prt? I didn't find that
Not uploaded yet..
Will be uploaded soon..
@@ssunitech6890 ok thnx..
There’s part 2 ?
Not uploaded yet .
Hi sir..you are uploading nice videos. i am facing an issue "the process exit code was while the expected was 0" while executing the the execute process task from .txt file to .zip file..
how can we fix the issue?
Lets connet
Name of this project please
Health care Project- Claims Analysis to save revenue.
can you provide me the data file?
so i can practise.
Sure Rachita,
Can you please share the Email address so I can forward to you.
Thanks.
@@ssunitech6890
rachita2410.rk@gmail.com
Thank you.
hello sir ,
I need help regarding a project, could you please help me with that. How can I contact you
Sure