--Check if linked server is up and running.

--Uses trusted connection. -t = timeout in seconds

declare @iServerStatus int,

@sSQL varchar(200),

...

I am not quite sure what you try to accomplish. Why do you need the data island to process xml file?. Just use xsl stylesheet to display content of the...

What is the text file format? Delimited, fixed lenght?

To import the text file with "abnormal" characters it has to be in fixed lenght or delimited with some custom delimiters that...

-- Install WinZip. It has to be licensed version.

-- Download and install command line utility wzzip.exe from WinZip site.

-- Zip file. Delete original.

set @sCmd= '"c:\Program Files\WinZip\wzzip.exe" -ex -m \\FileServerName\e$\Temp\FileName.zip \\FileServerName\e$\Temp\FileName.txt'

EXEC...