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

#ssis #ssisinterviewquestionsandanswer #ssunitech
ssis interview questions for experienced | SSIS Project | ssis real time interview questions | ssis interview questions and answers

In session, you will also learn how to build several sorts of data flow tasks and extract data from a single source in this SSIS lesson, ssis relatime project.
1. How to load data from flat file to sql server table.
2. How to move file from source to archive folder.
3. How to rename and add timestamp in flat file name.
4. How to Zip file after moving to archive file.

download source files for practice:

Below is the videos for individual topics:
ssis tutorial part-03

ssis tutorial part-10.1

ssis tutorial part-50

ssis tutorial part-51

ssis tutorial part-65

File Name New Variable assignment:
"FF_CD_DerivedCol_"+
(DT_WSTR,4)YEAR(GETDATE()) + "_" + (DT_WSTR,4)MONTH(GETDATE()) + "_" + (DT_WSTR,4)DAY(GETDATE()) +".txt"

For Quiz-

Find Us On FaceBook-

[roshnisingh]

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.

[goluSingh-suxs]

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

[ravindrasingh]

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

[hemachitikina]

It was very helpful for me thanks a lot 🙏

[ZaiidRaza]

Tum bahot mast kaam krta hai Maqsood Bhai 👍 #ssunitech

[vaibhavsingh]

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

[da]

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

[da]

That's great effort Sunil garu 👍👍👍

[paradesinarasimha]

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 .

[kattamanideep]

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

[lakshayarora]

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

[shaikhafija]

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

[anitatrimukhe]

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 !

[valijoneshniyazov]

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!

[data]

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\"" +" \""+ + left(@[User::FileNameNew], len( @[User::FileNameNew] )-3)+"zip\""+ " \""+ @[User::FileNameNew]+"\""

[kantamore]

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

[sachdevaswethagmai]

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

[anilacharya]

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

[sudheermyneni]

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

[dildhundatahai]

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)