SSIS Interview Questions

1. What does a control flow do?

2. Generically explain what happens inside a data flow task?

3. Explain what ETL is?

4. Which task would...

I am quite a novice and learning SSIS. The package is stored on the local machine and the Database server is the different machine. I am accessing the data base...

Thanks Greg.........

I have done as you suggested still the error persists.........

Message

Executed as user: USAPH103A\SYSTEM. ...n 9.00.3042.00 for 64-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. ...

Thanks Vishal............. This is a great help.

Keep it up.

Thanks Chad,

I am attaching here with the execution plan of the query..... Please respond to that and let me know what can be done to fix this.

Regards,RV

Hi,

Thanks for the reply. I have attaches here with the execution plan, please have a look and I would appreciate your suggestions/comments.

Thanks...

RV