#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"
Find Us On YouTube- "Subscribe Channel to watch Database related videos" [ Ссылка ]
For Quiz-
[ Ссылка ]
Find Us On FaceBook-
[ Ссылка ]
Ещё видео!