Tum bahot mast kaam krta hai Maqsood Bhai 👍 #ssunitech
@ssunitech68903 жыл бұрын
Thanks Bhai, but my name is Susheel Singh
@roshnisingh76614 жыл бұрын
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.
@ssunitech68904 жыл бұрын
Thanks Roshani for your appreciation.. Please share to others
@goluSingh-su1xs5 жыл бұрын
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..
@ssunitech68905 жыл бұрын
Thanks dear.. Do practice it looks easy for you as well. Thanks keep watching videos
@ravindrasingh53044 жыл бұрын
One of the best video for checking your skill. Nice and easy to explain in interviews
@ssunitech68904 жыл бұрын
Thanks dear, Please share to others
@da8233 Жыл бұрын
That's great effort Sunil garu 👍👍👍
@ssunitech6890 Жыл бұрын
Thanks 👍 My name is Susheel not sunil 😜
@da8233 Жыл бұрын
@@ssunitech6890 that's my mistake
@vaibhavsingh40435 жыл бұрын
What a video..it seems very easy and very helpful to explain in interview.. Really waiting for this video.. Thanks for uploading
@ssunitech68905 жыл бұрын
Thanks Vaibhav
@paradesinarasimha52712 жыл бұрын
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 .
@ssunitech68902 жыл бұрын
Thanks for your appreciation 🙂 Already recorded video on the same Please check in SSIS tutorial playlist
@kattamanideep52812 жыл бұрын
Hi Sushil. These videos are very useful for us.please upload more real time projects on SSIS for practice purpose
@ssunitech68902 жыл бұрын
Thanks for your appreciation. I have already uploaded few of videos. kzbin.info/aero/PLNRxk1s77zfjbCU-BgnER0hrnf4TvY5A3
@da8233 Жыл бұрын
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
@ssunitech6890 Жыл бұрын
Glad to know it helped
@hemachitikina94663 жыл бұрын
It was very helpful for me thanks a lot 🙏
@ssunitech68903 жыл бұрын
Thanks for your appreciation. Please share to others
@lakshayarora39354 жыл бұрын
Very well explained brother. Keep it up and please keep on posting such project videos. We are waiting for them. Thanks in Advance:):)
@ssunitech68904 жыл бұрын
Thanks Lakshay.. Sure will upload move video for the same
@shaikhafija41714 жыл бұрын
very useful for us.please upload the project on SSRS for practice purpose.
@ssunitech68904 жыл бұрын
Thanks Shaik. Please share to others
@DeekshiWithDaddy2 жыл бұрын
Super video
@ssunitech68902 жыл бұрын
Thanks ☺️
@valijoneshniyazov38594 жыл бұрын
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!
@ssunitech68904 жыл бұрын
Thanks a lot. In my case it's happening. You can use the same way that i did. Thanks
@nagmanchi2 жыл бұрын
Hi sir, for renaming zip files we have to download 7zip (or) default it will have in windows?
@ssunitech68902 жыл бұрын
We have to download 7zip.
@sudheermyneni4 жыл бұрын
This is very helpful, are there any continuation videos or any other more case studies
@ssunitech68904 жыл бұрын
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
@anitatrimukhe9354 жыл бұрын
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 !
@ssunitech68904 жыл бұрын
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
awesome video n thanks, please share link of part 2.
@ssunitech68904 жыл бұрын
Thanks. Didn't upload part 2. I didn't get many requests that's what didn't recorded. But will do.
@kantamore15124 жыл бұрын
@@ssunitech6890 ohhh, btw thanks once again..
@sachdevaswetha02gmai2 жыл бұрын
hi sushi, this video was very good.how would u loop thru files for archiving all the files
@ssunitech68902 жыл бұрын
Check in next projects
@dildhundatahai98464 жыл бұрын
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)
@ssunitech68904 жыл бұрын
Sure will do brother.
@dildhundatahai98464 жыл бұрын
@@ssunitech6890 thank you.. Bro..
@nitagawade33304 жыл бұрын
Thank you so much Sushil🙏
@ssunitech68904 жыл бұрын
Thanks Nita
@chandrakalakv56303 жыл бұрын
nyc explanation, i have one question.how to load data from client tostaging table and staging table to transactional table
@ssunitech68903 жыл бұрын
Thanks. We will be having 3 databases, 1. Testing 2. Staging 3. Main database
@joegodindata2 жыл бұрын
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]+"\""
@ssunitech68902 жыл бұрын
Thanks 👍
@jayakrishna98644 жыл бұрын
Appreciate your videos, can I expect SSAS real time videos from your channel, please
@ssunitech68904 жыл бұрын
Will upload videos on SSAS after Power BI. Thanks for your appreciations
@Maha-yf9gv4 жыл бұрын
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?
@ssunitech68904 жыл бұрын
It should work.. Call me +919971652428 if you are unable to do this
@Maha-yf9gv4 жыл бұрын
Wow that's really great response brother.. Kuddos.. Definitely will reach out to you. Once again thank you so much.
@ssunitech68904 жыл бұрын
Any time bro
@humafirdaus92924 жыл бұрын
Can you please explain this to me as well through my e-mail humafirdaus1014@gmail.com
@daudjamilurrahman4658 Жыл бұрын
Hi Mr Sushil, where can I get the source data and SSIS solution file that you showed in this video
@ssunitech6890 Жыл бұрын
Please check the description of the video I have added source data in zil file
@shabnamattar56322 жыл бұрын
Hi,if big data then can we use direct query rather than create project in SSIS,SSAS
@ssunitech68902 жыл бұрын
That will not work, you have to include any etl tool.
@anilacharya4673 жыл бұрын
Hi Sir ji, Please provide Azure and Azur Data Factory real time project also.
@ssunitech68903 жыл бұрын
Sure Thanks
@hajaaa1003 жыл бұрын
Like this SSIS can you explain any power bi project to explain in interview
@ssunitech68903 жыл бұрын
Thanks.. Please check i have uploaded more than 10 videos..
@da8233 Жыл бұрын
Sunil I'm trying to join membership , but join button automatically shown purchase cancel I don't know why
@ssunitech6890 Жыл бұрын
Don't know why it's happening
@tarunkumar_11385 жыл бұрын
Tq sir.... and I need small help from u sir... what are the SQL concepts are required for msbi sir
@ssunitech68905 жыл бұрын
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
@tarunkumar_11385 жыл бұрын
@@ssunitech6890 tq so much sir
@fruite_1453 жыл бұрын
We need more projects
@ssunitech68903 жыл бұрын
Sure. I am working on a project once done I will record and upload for sure. Thanks
@SlicerJi3 жыл бұрын
Can you please make a video in completely like dev qa and pord
@ssunitech68903 жыл бұрын
Sure..
@da8233 Жыл бұрын
could you give me more info , what are benefits i got in case im taking you subscription ???
@ssunitech6890 Жыл бұрын
Will share the source files
@mastanvallishake91913 жыл бұрын
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!
@ssunitech68903 жыл бұрын
Watch this video to understand about loading data from multiple files
@ssunitech68903 жыл бұрын
kzbin.info/www/bejne/e6LKnZibZp1-ldU
@gayathrir63964 жыл бұрын
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...
@ssunitech68904 жыл бұрын
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
@bukkenagamuninaik18357 ай бұрын
If we have 5 files then we need to do like this for all then???
@ssunitech68906 ай бұрын
Use one for each loop, and perform all these steps under for each.
@shaiksharief7463 жыл бұрын
Hi sir, for moving All files dynamically, can we use for each loop container?
@ssunitech68903 жыл бұрын
Yes we can
@raghuvamsialluri21052 күн бұрын
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".
@abhijith5014 жыл бұрын
please do the same video using for loop
@ssunitech68904 жыл бұрын
Did u check SSIS tutorial playlist?? I have already uploaded videos on looping.
@DeekshiWithDaddy2 жыл бұрын
Hi bro ,I did same process but error this " could not find a part of the path " how to solve please ?
@ssunitech68902 жыл бұрын
The path will not be in your system.
@antarabhattacharjee32943 жыл бұрын
Hi,Do you have any other projects for SSIS?
@ssunitech68903 жыл бұрын
No we don't have any other projects at yet.
@sivamanideepdarisa13363 жыл бұрын
Can you show the DB to json file with specific name and date and unique I'd also
@ssunitech68903 жыл бұрын
Will record a video on the same.
@valijoneshniyazov38594 жыл бұрын
SIR, move file task and rename file task can be done in 1 file system task!
@ssunitech68904 жыл бұрын
Yes we can do this. Thanks
@koteswararao21784 жыл бұрын
This proces only .TXT files or any files. In same process?
@ssunitech68904 жыл бұрын
Yes it's designed for flat files. You can change the source as you want. Thanks
@joegodindata2 жыл бұрын
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."
@joegodindata2 жыл бұрын
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.
@ssunitech68902 жыл бұрын
Thanks 🙏
@paradesinarasimha52712 жыл бұрын
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.
@ssunitech68902 жыл бұрын
You can download the 7zip and then test it
@sudiptanath4103 Жыл бұрын
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.
@ssunitech6890 Жыл бұрын
Don't know, but i opened it's working
@rameshandala33713 жыл бұрын
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?
@ssunitech68903 жыл бұрын
Lets connet
@lokendrak.c2783 жыл бұрын
What is the advantage of joining tge chamnel ?
@ssunitech68903 жыл бұрын
Many advantages you can get all the source files free for practice.
@priyankasarkar66003 жыл бұрын
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..
@ssunitech68903 жыл бұрын
Sure. I have already uploaded 70+ videos on SSIS. Will try to do interview questions and answers
@rajeshvattivella99295 жыл бұрын
Very useful but data load to data warehouse not explain and also SQL concept not explain
@ssunitech68905 жыл бұрын
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
@rajeshvattivella99295 жыл бұрын
Data load flats file to SQL server I know but project point of view data load fact and dimensions table.
@ssunitech68904 жыл бұрын
Ok will upload..
@jaideepmalik10285 жыл бұрын
You made dynamic connection but u didnt explain by changing file name..
@ssunitech68905 жыл бұрын
I explained in second part of the video. As you can see I used filenamenew variable for renaming file.
@jaideepmalik10285 жыл бұрын
@@ssunitech6890 have u uploaded 2nd prt? I didn't find that
@ssunitech68905 жыл бұрын
Not uploaded yet.. Will be uploaded soon..
@jaideepmalik10285 жыл бұрын
@@ssunitech6890 ok thnx..
@saiddekkaki34564 жыл бұрын
There’s part 2 ?
@ssunitech68904 жыл бұрын
Not uploaded yet .
@eswarchandu27213 жыл бұрын
Name of this project please
@ssunitech68903 жыл бұрын
Health care Project- Claims Analysis to save revenue.
@rachitakadam194 жыл бұрын
can you provide me the data file? so i can practise.
@ssunitech68904 жыл бұрын
Sure Rachita, Can you please share the Email address so I can forward to you. Thanks.