sql server - SSIS failure scenario triggered all the time -


i have problem flow in ssis package. increasing performance have same logic importing data ms access files sql server database:

  • 1st task - try bulk insert data (table or view - fast load)
  • if there failure (e.g. constraint violation), whole bunch of records passed next task - normal insert (table view)
  • all problem records passed next steps loggin flat files (txt)

the problem face when first insert went fine, still reach failure flow , empty error log file created time. in understanding process should reach point in case there problems before.

for better understanding attach image execution results , there green ticks end.

would appreciate advice workaround. need create error log files - when there error details problem.

thanks!

wrong flow in ssis package

i think may confusing data flow control flow degree.

the stockexchange - error log created may receive records dataflow.

the way around be:

1) create temporary error log file temporary hold failed rows, or 0 rows if successful in temporary location.

2) after "stockexchange - error desc" component add rowcount component , assign variable e.g. ierrorcount

3) in control flow, after data flow add 2 precedence constraints. 1 @ierrorcount > 0 , 1 @ierrorcount ==0. if it's 0 add file system task delete temporary log file (has has 0 rows)

4) @errorcount > 0 path, add file system task copy temporary log file required location valid name. , add file system task delete temporary log file.


Comments

Post a Comment

Popular posts from this blog

matlab - Deleting rows with specific rules -

i got 20*3 cell array , need delete rows contains "137", "2" , "n:t" origin data: 't' '' '' 'np(*)' '' '' [ 137] '' '' [ 2] '' '' 'are' 'and' 'np(fcc_a1#1)' '' '' '1:t' [ 1200] [0.7052] '' [1.2051e+03] [0.7076] '' 'are' 'and' 'np(fcc_a1#3)' '' '' '2:t' [ 1200] [0.0673] '' [1.2051e+03] [0.0671] '' 'are' 'and' 'np(m23c6)' '' '' '3:t' [ 1200] [0.227...
Read more

php - MySQLi multi_query results for later use -

i using mysqli multi_query work several select statemets @ time. know how handle results, able use them later in code. example: <?php //connection stuff $query = "select name, surname database1;"; $query.= "select car, year, type database2 carid='1';"; $query.= "select product, price database3;"; if ($mysqli->multi_query($query)) { if($result = $mysqli->store_result()) { while($row = $result->fetch_row()) { --> here? } } } ?> <html> <div id='persona'> <?php foreach() { --> print name + surname } ?> </div> <div id='cars'> <?php foreach() { --> print car + year + type } ?> </div> <div id='product'> <?php foreach() { --> print product + price } ?> </div> </html> one more thing, prepared statements not possible when using multiple_query, right? there no benefit in putting unrelated queries in 1 multi ...
Read more