Dear all

In SSIS I want to write the error rows in the dataflow of a package to a row
file. This works well. But if I have no errors, I do NOT want to create a raw
file. How can I achieve this?

Regards,

Marc

Hi Marc,

Thank you for using MSDN Managed Newsgroup Support.

Based on my scope, you could set the Data source Error Output to the Raw
file destination.

I don't think you could set the precondition in the Data flow.

Here is a option you may use from community members.

http://groups.google.com/group/micro...browse_frm/thr
ead/8e6f01122295fe5/546ba6ed896888dc

Hope this will be helpful.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

Hi Wei

I tried to use the row count error output to the raw file destination, but
it created the file either if there were errors or if there where no errors.
I implemented a script task in the control flow which checks at the end of
the package the errors occured - if there aren't any it deletes the file just
created. Its not that nice but it works.

Best regards,

Marc

Hi Marc,

Thanks for the update. Glad to hear you resolve this issue by add a script
to delete the file.

If you have any questions or concerns, please feel free to let me know.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.