Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Welcome To Ask or Share your Answers For Others

Categories

0 votes
492 views
in Technique[技术] by (71.8m points)

zipfile - SSIS Zip Task on an Loop

On SSIS on the Control Flow I have a Zip Task by IlionX.

There was a situation in which the task was in a loop and the process did not end, I had to ended it manually. In the folder where the zip should have been generated, a DotNetZip-a00h0hof.tmp file was generated and that's when the tasks starts looping and not generating the zip or going to the next task. I tried to process again the same file and the behavior is the same. There is nothing on the Execution Results that explains why it's stuck on the loop.

I divided the file in two and that way it processed without error both files. I was expecting to pass without error one file and on the other part of the file to go on loop, but no, it processed both sucessfully.

It's a csv file with 3000 rows.

This package has processed many similar files and it's the first time I encounter this error.

This is the zip task

enter image description here

Do you have any suggestions on how to solve this or to get a better understanding why this happened?

Thanks in advance


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
Welcome To Ask or Share your Answers For Others

1 Reply

0 votes
by (71.8m points)
等待大神答复

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
OGeek|极客中国-欢迎来到极客的世界,一个免费开放的程序员编程交流平台!开放,进步,分享!让技术改变生活,让极客改变未来! Welcome to OGeek Q&A Community for programmer and developer-Open, Learning and Share
Click Here to Ask a Question

...