SSIS package - can it open TP in Hex view of a text file?

[slmehl]

Hello --

Our SSIS package creates a text file from the results of a SQL query.
After that, we want the package to open the file in TextPad in Hex view so we can inspect it.

Can anyone tell me how to do this?

Thanks in advance for any help.

Larry Mehl

[miked]

If your SSIS package can run external programs you need to get it to put a line number in hex proceeded by 0x in brackets after the file name eg:

Code: Select all

textpad.exe test.txt (0x01)

This forces textpad into hex mode.