One of my interview question in SSIS:
I have nightly SSIS packages are running every day. And this package is schduled to load the 10 flat files into OLEDB database in every 10 minutes. Now i got one wrong or corrupted Flat file.
The Question is:
Configure a DTSX package if there is any Corrupted file came with missing columns or Delimeters the it should move into the Error Path Location.
How to move Bad or Corrupted flat files or excel files in to the error path?
Answer:
Makesure Maximum Error count is more than zero.
Basically Maximum Error Count will avoid maximun number of errors.
I have nightly SSIS packages are running every day. And this package is schduled to load the 10 flat files into OLEDB database in every 10 minutes. Now i got one wrong or corrupted Flat file.
The Question is:
Configure a DTSX package if there is any Corrupted file came with missing columns or Delimeters the it should move into the Error Path Location.
How to move Bad or Corrupted flat files or excel files in to the error path?
Answer:
Basically Maximum Error Count will avoid maximun number of errors.
Variable: Create a Variable inorder to MAP the For Each Loop Container and Excel Connection manager(Souce)
Let me share more thought on this senarios.
Thank you
Vidya Sagar Malla
No comments:
Post a Comment