Thanks for the replies. I read the reviews and based on these and also the described content of the books, I decided that the one which sounded like it most...

My workround was to add a blank row below the titles and format this in the way I wanted. The only downside is there is then one blank row below...

Matthias, sorry if I am missing the obvious.

I can see how this works if I run the procedure from Query Analyzer, I see the result in the messages pane....

Yes I appreciate that. My question was, given I make a mistake e.g. I run on a server which can not see the path because it is on another server,...

I struggled a bit getting this to work in a loop in DTS with a changing file names. In the end created a stored procedure below and called this from...

Could do with a little bit more help please.

I adpated the example to step through my table and create a string.

Now I need to adapt this package so that it...

Thanks for your replies, I went for the loop through a Rowset solution as it keeps everything in a DTS package.

Took me some time to fathom out how this works....

quote:

---

If IsEmpty(arrAddresses) Then

---

Many thanks, that did the trick

Stefan

Thanks, will download command version to be on the safe side

Stefan

Wunderbar!

Just one small question, I used:

set @cmdshell = 'C:\Progra~1\WinZip\WINZIP32.EXE -a ' + @zipfile + ' ' + @xlsfile

This seems to work perfectly. Would there be an advantage installing the command...

In Access I have quite a bit of code which ultimately run a command line something like the following:

C:\Program Files\WinZip\winzip32 -min -a C:\temp\temp.zip C:\temp\temp.xls

How would I call the same command...

As mentioned above, I don't think this is possible in SQL view

Please explain how and where you want to put these comments:

In the database window?

Right mouse click the name of the query. Enter comments in the description, on the view menu...

quote:

---

You say In Enterprise Manager you have created a linked Server to your Production Server.

that means SQL Server was running on...

I am fairly certain that I have only one instance on this server. How can I tell?

In Enterprise Manager I have created a linked Server to my Production Server. Is...