How to get output from a MsgBox into an output

[edwardturner]

Hi,

I have a DTS package that takes an Excel spreadsheet as the input and then runs an update statement on a SQL database based upon certain conditions. The data is rejected if an associated database record cannot be found to update, in these cases I can output the details of source row that has not been brought in using a MsgBox.

There about 200 cases of this failure so ideally would summarise this information into a txt file or some form of output.

I have copied the data pump task that perform the orignal translation and change the destination to be a source file but I just get an error:

".. error creating datafile mapping: The volume for a file has been externally altered so that the opened file is no longer valid .."

My source file is populated and I have created my source file (output.txt) on the root of my C drive.

Any ideas?

 

[123FakeSt]

Can you store the rejected data in a table rather than a text file?

I am confused about the msgbox, is it in an ActiveX script?

The early bird gets the worm, but the second mouse gets the cheese.

 

[mutley1]

Ed,

1. Does the file you are trying to write to exist on the server?
2. Are you getting the error through a scheduled job / running the DTS from EM on your PC or actually on the server (infront of it / Term Services etc. etc.)
3. Have you changed the target file (if it exists) since writing the script etc.

I've had this before and wracking my brains as I know it was something simple but just cant remember at the moment!

Cheers,

M.