1. Name few of the Sources available in SSIS
Ans:-ADO NET Source,Excel Source,Flat File Source,OLE DB Source,Raw File Source and XML Source.
2. If we need to read XML Source file which Source we will use in SSIS
Ans:-XML Source
3. What problems you have faced when you used Excel Source.
Ans:-(32-bit and 64-bit) Drivers Comparability issue, Truncation issue(row size)
4. How will you handle a column such as comments that has more than 255 characters in excel at row number 1000.
5. What is fast parse property in Flat File Source? What are the requirements and limitation to use this property
Ans:-ADO NET Source,Excel Source,Flat File Source,OLE DB Source,Raw File Source and XML Source.
2. If we need to read XML Source file which Source we will use in SSIS
Ans:-XML Source
3. What problems you have faced when you used Excel Source.
Ans:-(32-bit and 64-bit) Drivers Comparability issue, Truncation issue(row size)
4. How will you handle a column such as comments that has more than 255 characters in excel at row number 1000.
5. What is fast parse property in Flat File Source? What are the requirements and limitation to use this property
No comments:
Post a Comment