SSIS Project | ssis real time interview questions | how to explain about ssis project in interviews

[@ZaiidRaza]

Tum bahot mast kaam krta hai Maqsood Bhai 👍 #ssunitech

[@ssunitech6890]

Thanks Bhai, but my name is Susheel Singh

[@roshnisingh7661]

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.

[@ssunitech6890]

Thanks Roshani for your appreciation.. Please share to others

[@goluSingh-su1xs]

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..

[@ssunitech6890]

Thanks dear.. Do practice it looks easy for you as well. Thanks keep watching videos

[@ravindrasingh5304]

One of the best video for checking your skill. Nice and easy to explain in interviews

[@ssunitech6890]

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

[@vaibhavsingh4043]

What a video..it seems very easy and very helpful to explain in interview.. Really waiting for this video.. Thanks for uploading

[@ssunitech6890]

Thanks Vaibhav

[@paradesinarasimha5271]

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 .

[@ssunitech6890]

Thanks for your appreciation 🙂 Already recorded video on the same Please check in SSIS tutorial playlist

[@kattamanideep5281]

Hi Sushil. These videos are very useful for us.please upload more real time projects on SSIS for practice purpose

[@ssunitech6890]

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

[@hemachitikina9466]

It was very helpful for me thanks a lot 🙏

[@ssunitech6890]

Thanks for your appreciation. Please share to others

[@lakshayarora3935]

Very well explained brother. Keep it up and please keep on posting such project videos. We are waiting for them. Thanks in Advance:):)

[@ssunitech6890]

Thanks Lakshay.. Sure will upload move video for the same

[@shaikhafija4171]

very useful for us.please upload the project on SSRS for practice purpose.

[@ssunitech6890]

Thanks Shaik. Please share to others

[@DeekshiWithDaddy]

Super video

[@ssunitech6890]

Thanks ☺️

[@valijoneshniyazov3859]

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!

[@ssunitech6890]

Thanks a lot. In my case it's happening. You can use the same way that i did. Thanks

[@nagmanchi]

Hi sir, for renaming zip files we have to download 7zip (or) default it will have in windows?

[@ssunitech6890]

We have to download 7zip.

[@sudheermyneni]

This is very helpful, are there any continuation videos or any other more case studies

[@ssunitech6890]

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

[@anitatrimukhe935]

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 !

[@ssunitech6890]

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

[@anitatrimukhe935]

@@ssunitech6890 thanku . please upload videos soon. :-)

[@kantamore1512]

awesome video n thanks, please share link of part 2.

[@ssunitech6890]

Thanks. Didn't upload part 2. I didn't get many requests that's what didn't recorded. But will do.

[@kantamore1512]

@@ssunitech6890 ohhh, btw thanks once again..

[@sachdevaswetha02gmai]

hi sushi, this video was very good.how would u loop thru files for archiving all the files

[@ssunitech6890]

Check in next projects

[@dildhundatahai9846]

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)

[@ssunitech6890]

Sure will do brother.

[@dildhundatahai9846]

@@ssunitech6890 thank you.. Bro..

[@nitagawade3330]

Thank you so much Sushil🙏

[@ssunitech6890]

Thanks Nita

[@chandrakalakv5630]

nyc explanation, i have one question.how to load data from client tostaging table and staging table to transactional table

[@ssunitech6890]

Thanks. We will be having 3 databases, 1. Testing 2. Staging 3. Main database

[@joegodindata]

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]+"\""

[@ssunitech6890]

Thanks 👍

[@jayakrishna9864]

Appreciate your videos, can I expect SSAS real time videos from your channel, please

[@ssunitech6890]

Will upload videos on SSAS after Power BI. Thanks for your appreciations

[@Maha-yf9gv]

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?

[@ssunitech6890]

It should work.. Call me [phone] if you are unable to do this

[@Maha-yf9gv]

Wow that's really great response brother.. Kuddos.. Definitely will reach out to you. Once again thank you so much.

[@ssunitech6890]

Any time bro

[@humafirdaus9292]

Can you please explain this to me as well through my e-mail [e-mail]

[@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

[@shabnamattar5632]

Hi,if big data then can we use direct query rather than create project in SSIS,SSAS

[@ssunitech6890]

That will not work, you have to include any etl tool.

[@anilacharya467]

Hi Sir ji, Please provide Azure and Azur Data Factory real time project also.

[@ssunitech6890]

Sure Thanks

[@hajaaa100]

Like this SSIS can you explain any power bi project to explain in interview

[@ssunitech6890]

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_1138]

Tq sir.... and I need small help from u sir... what are the SQL concepts are required for msbi sir

[@ssunitech6890]

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_1138]

@@ssunitech6890 tq so much sir

[@fruite_145]

We need more projects

[@ssunitech6890]

Sure. I am working on a project once done I will record and upload for sure. Thanks

[@SlicerJi]

Can you please make a video in completely like dev qa and pord

[@ssunitech6890]

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

[@mastanvallishake9191]

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!

[@ssunitech6890]

Watch this video to understand about loading data from multiple files

[@ssunitech6890]

kzbin.info/www/bejne/e6LKnZibZp1-ldU

[@gayathrir6396]

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...

[@ssunitech6890]

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

[@bukkenagamuninaik1835]

If we have 5 files then we need to do like this for all then???

[@ssunitech6890]

Use one for each loop, and perform all these steps under for each.

[@shaiksharief746]

Hi sir, for moving All files dynamically, can we use for each loop container?

[@ssunitech6890]

Yes we can

[@raghuvamsialluri2105]

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".

[@abhijith501]

please do the same video using for loop

[@ssunitech6890]

Did u check SSIS tutorial playlist?? I have already uploaded videos on looping.

[@DeekshiWithDaddy]

Hi bro ,I did same process but error this " could not find a part of the path " how to solve please ?

[@ssunitech6890]

The path will not be in your system.

[@antarabhattacharjee3294]

Hi,Do you have any other projects for SSIS?

[@ssunitech6890]

No we don't have any other projects at yet.

[@sivamanideepdarisa1336]

Can you show the DB to json file with specific name and date and unique I'd also

[@ssunitech6890]

Will record a video on the same.

[@valijoneshniyazov3859]

SIR, move file task and rename file task can be done in 1 file system task!

[@ssunitech6890]

Yes we can do this. Thanks

[@koteswararao2178]

This proces only .TXT files or any files. In same process?

[@ssunitech6890]

Yes it's designed for flat files. You can change the source as you want. Thanks

[@joegodindata]

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."

[@joegodindata]

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.

[@ssunitech6890]

Thanks 🙏

[@paradesinarasimha5271]

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.

[@ssunitech6890]

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

[@rameshandala3371]

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?

[@ssunitech6890]

Lets connet

[@lokendrak.c278]

What is the advantage of joining tge chamnel ?

[@ssunitech6890]

Many advantages you can get all the source files free for practice.

[@priyankasarkar6600]

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..

[@ssunitech6890]

Sure. I have already uploaded 70+ videos on SSIS. Will try to do interview questions and answers

[@rajeshvattivella9929]

Very useful but data load to data warehouse not explain and also SQL concept not explain

[@ssunitech6890]

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

[@rajeshvattivella9929]

Data load flats file to SQL server I know but project point of view data load fact and dimensions table.

[@ssunitech6890]

Ok will upload..

[@jaideepmalik1028]

You made dynamic connection but u didnt explain by changing file name..

[@ssunitech6890]

I explained in second part of the video. As you can see I used filenamenew variable for renaming file.

[@jaideepmalik1028]

@@ssunitech6890 have u uploaded 2nd prt? I didn't find that

[@ssunitech6890]

Not uploaded yet.. Will be uploaded soon..

[@jaideepmalik1028]

@@ssunitech6890 ok thnx..

[@saiddekkaki3456]

There’s part 2 ?

[@ssunitech6890]

Not uploaded yet .

[@eswarchandu2721]

Name of this project please

[@ssunitech6890]

Health care Project- Claims Analysis to save revenue.

[@rachitakadam19]

can you provide me the data file? so i can practise.

[@ssunitech6890]

Sure Rachita, Can you please share the Email address so I can forward to you. Thanks.

[@rachitakadam19]

@@ssunitech6890 [e-mail] Thank you.

[@hitheshnekkanti6902]

hello sir , I need help regarding a project, could you please help me with that. How can I contact you

[@ssunitech6890]

Sure