Hmmm very very weird behaviour :s
We have an Execute SQL task that calls a stored procedure containing xp_cmdshell to BCP out 2 tables and some other stuff. Somewhere after the export of the second one the step reports to be completed successfully although there are a couple commands that need to be executed after the BCP (in the same stored procedure).
Apparently - still investigating though - using NO_OUTPUT solves the problem
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment