DTS = Data Transformation Services. Basically given an known datasource, DTS can extract and transform data very easily.

There are different methods of calling BCP, xp_cmdshell is one of them,...

Craig

If you're using the latest download of SQLH2, you can use the /D parameter to set the date format.

Check the Deployment documentation for details.

In your DTS package you can have a short ActiveX Script task that extracts a list of sheet names and set the connection properties.

Open the Excel workbook using an ADO...

A seperate OLAP instance would be advantageous. Given that your base tables may have high transaction volume, you don't want to be delaying transaction processing while a report is being run....

How about you try Books Online

"Returns the number of rows affected by the last statement."

 

So basically,

- you have information in a SQL table that you want to export to CSV

- you have an existing Oracle PL/SQL that you want to reproduce in SQL...

Igor

If you would like to publish your functions at our Australian site feel free to do so. After registering at the site, post your functions in the resources section

Firstly, to avoid the "Don't use cursors" mantra, you should be explaining why it is necessary to use the cursor.

If you have to use the cursor, can you just have key...

Then maybe posting this to the forums is the wrong approach.

How about posting it to the script library, or talk to the guys running the site on how it may...

The DTS package is probably awaiting for a response to message prompt at the server console. eg: MsgBox prompt in VBScript.

If you can't log into the server console directly,...

Well my response was to your original post

So you declare two local SQL variables, call your stored procedure with an output parameter to...

Ok, I don't really like posting huge long messages, but this is really weird.

Just to get all the specs out,

Server is running Windows 2000 Server with SQL Server Desktop...

Haven't had much call to add images yet, but can't you add the images using a URL reference?

Noel

I'm connecting with 'sa' privelages to run my query and sp_databases. So I guess that rules out access permissions.

Ehh ?!?

So what's wrong with my idea? Upload all the items to a single folder via CreateReport then move them using MoveItem (see below). Now that I'm looking at it...