1. What is Data Flow Task
Ans:-As the name suggest, Data Flow Task is nothing but flow of data from Source to the Destination.That's what exactly ETL does,Extract-Transform-Load of data.Most of the ETL is done in the data flow task.
2. If you need to run some SQL script( stored procedure, DML,DDL ) which task you will use in Control Flow
Ans:-We can use Execute SQL Task to run SQL Script .
3. If you have create object type variable that you want to use in script task later, how you will load data into Object Type variable in Control flow, which task will help
Ans:-
4. If your database in Full Recovery mode cans you use Bulk Insert Task to load data? What are requirements to use Bulk Insert Task ?
Ans:-In Full Recovery mode all Bulk operations are FULLY logged.you can minimize logging for a set of bulk operations by switching the database to the bulk-logged recovery model temporarily for bulk operations.Large data imports can cause the transaction log to fill rapidly if the full recovery model is used.
5. If your company is using Ftp site to receive daily data files, which task you will use to download/upload/Delete files on FTP Site ?
Ans:-FTP Task
6. What is difference between Script task and Script component
Ans:-The basic functionality of the Script Task and Script Component is to extend the functionality of SSIS by writing your own custom scripts if no built-in transformation full fills your requirements. Though the purpose is same for both items, where these tasks are used is different. The Script Task is used in control flow to accomplish almost any general-purpose task, like connecting to web services, sending out HTML formatted mails.The Script Component is used in the data flow designer to extend the functionality of the source, transformation and destination and typically runs for each row. In SQL Server 2008 you can use either Visual Basic .NET or C# to write code for the Script Task or Script Component.
7. What script languages are available for you to do scripting in Script task and script component
Ans:- In SQL Server 2008 you can use either Visual Basic .NET or C# to write code for the Script Task or Script Component.
8. What is difference between ReadOnlyVariables and ReadWriteVariable in Script task ?
Ans:-
9. Can you do debugging in Script task or Script component in SSIS 2012 ?
10. You have create 5 packages, you want to call all of them in one package, which task you can use to call them ?
11. You have deployed your SSIS Package to Integration Services Server, Can you still call them in Parent Package ?
Ans:-Yes we can call them in Parent package.
12. If you load set of big files, after each load you want to zip them and put into archive folder. Which task you need to use to Zip them
13. Which task you can use to delete, rename, move files and folders
14. Can you rename and move file by using one task, which task is that and how you will do that
15. If your data flow task fails in Control Flow, which task you will use to send email on Error
16. Before you create your SSIS Package and load data into destination, you want to analyze your data , which task will help you to achieve that
17. What is WSDL and in which task you have to use it
18. You have loaded email addresses in Object type variable, now you want to send email to each of the address you have in object type variable, which task you will use to loop through and send email one by one
19. There are 10 files in folder, we want to load them one by one, which tasks are required to perform this job
20. You have a lot of Tasks sitting in Control Flow task , you want to group them, which container can help you to achieve that
21. You got this assignment where you want to perform the same task 10 times, which loop you will use to do that
22. Name few of the task those are available to create Maintenance plan or those can perform DBA tasks such as Create indexes, take backup etc.
23. In Execute SQL Task what is Result Set( Single Row, Full Result Set,XML)
Ans:-As the name suggest, Data Flow Task is nothing but flow of data from Source to the Destination.That's what exactly ETL does,Extract-Transform-Load of data.Most of the ETL is done in the data flow task.
2. If you need to run some SQL script( stored procedure, DML,DDL ) which task you will use in Control Flow
Ans:-We can use Execute SQL Task to run SQL Script .
3. If you have create object type variable that you want to use in script task later, how you will load data into Object Type variable in Control flow, which task will help
Ans:-
4. If your database in Full Recovery mode cans you use Bulk Insert Task to load data? What are requirements to use Bulk Insert Task ?
Ans:-In Full Recovery mode all Bulk operations are FULLY logged.you can minimize logging for a set of bulk operations by switching the database to the bulk-logged recovery model temporarily for bulk operations.Large data imports can cause the transaction log to fill rapidly if the full recovery model is used.
5. If your company is using Ftp site to receive daily data files, which task you will use to download/upload/Delete files on FTP Site ?
Ans:-FTP Task
6. What is difference between Script task and Script component
Ans:-The basic functionality of the Script Task and Script Component is to extend the functionality of SSIS by writing your own custom scripts if no built-in transformation full fills your requirements. Though the purpose is same for both items, where these tasks are used is different. The Script Task is used in control flow to accomplish almost any general-purpose task, like connecting to web services, sending out HTML formatted mails.The Script Component is used in the data flow designer to extend the functionality of the source, transformation and destination and typically runs for each row. In SQL Server 2008 you can use either Visual Basic .NET or C# to write code for the Script Task or Script Component.
7. What script languages are available for you to do scripting in Script task and script component
Ans:- In SQL Server 2008 you can use either Visual Basic .NET or C# to write code for the Script Task or Script Component.
8. What is difference between ReadOnlyVariables and ReadWriteVariable in Script task ?
Ans:-
9. Can you do debugging in Script task or Script component in SSIS 2012 ?
10. You have create 5 packages, you want to call all of them in one package, which task you can use to call them ?
11. You have deployed your SSIS Package to Integration Services Server, Can you still call them in Parent Package ?
Ans:-Yes we can call them in Parent package.
12. If you load set of big files, after each load you want to zip them and put into archive folder. Which task you need to use to Zip them
13. Which task you can use to delete, rename, move files and folders
14. Can you rename and move file by using one task, which task is that and how you will do that
15. If your data flow task fails in Control Flow, which task you will use to send email on Error
16. Before you create your SSIS Package and load data into destination, you want to analyze your data , which task will help you to achieve that
17. What is WSDL and in which task you have to use it
18. You have loaded email addresses in Object type variable, now you want to send email to each of the address you have in object type variable, which task you will use to loop through and send email one by one
19. There are 10 files in folder, we want to load them one by one, which tasks are required to perform this job
20. You have a lot of Tasks sitting in Control Flow task , you want to group them, which container can help you to achieve that
21. You got this assignment where you want to perform the same task 10 times, which loop you will use to do that
22. Name few of the task those are available to create Maintenance plan or those can perform DBA tasks such as Create indexes, take backup etc.
23. In Execute SQL Task what is Result Set( Single Row, Full Result Set,XML)
No comments:
Post a Comment