Take a look at the DTSFTP task over at http://www.sqldts.com

Thanks Steve.

No there wasn't any misunderstanding. In the .bas file there is a line that reads,

goPackage.Execute

just above this line is a line that is commented out. It'll be something...

That is what he has used but a few of the lines in the code section are very long, therefore the article becomes too wide.

To illustrate this I've formatted the...

If you're saving the packages outside of SQL Server, or modifying them programmatically, then you will lose the layout and all text annotations. This is because these items are not...

The problem is created by the use of preformatted text so the code displays in a more readable manner. When the or <PRE></PRE> tags are used the browser doesn't...

I did about 120 packages at one go.

All I did was put all the seperate .bas files into a Visual Basic Project and performed a find & replace across all...

Thanks for that, its always a good day when you learn something new

To render a report in a format that is not listed you'll need to either a) source the required rendering extension on the internet or b) write you own rendering...

If this is just your test database and you don't need to worry about the transaction log for recovery, then I'd do the following.

1. Set the recovery model of the database...

Check the SQL Server Log and/or the Windows Event log and you should see a message along the lines of

"SQL server listening on x.x.x.x: yyyy"

Where x.x.x.x is the ip of...

First point of call would be to use the Process object in System Monitor and determine if SQL is using the CPU.

A high processor Queue length could be caused by...

Check this

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=19&messageid=18439

We are running SQL 2000 Sp4

Hmm ... I may be missing something here but I don't see where there is an issue with the code sample you've provided. For both the select statements I get

-----------...