Thats the way I'm reading it. by just not 100% .

Thanks for your input.

Thanks John.

In nice to know it appreciated. 😀

Well basically I agree with the methodology breaking a project into logical work units,

such as build Customer Dimension, build CustomerSales fact table.

Some of our DW project on SQL2000 are now...

Hi, thanks for that. It looks like a useful tool and i've also taken a look at a publish from Artis Consulting (http://www.artis consulting.com/blogs/greggalloway/Lists/Posts/Post.aspx?ID=15) on how they publish packages,...

no, i'll check it.

Thanks

Ok.

I tried taking the approach of setting a variable string to try and dynamically set the path and file name (I could see a variable for the name), the I...

thanks for the reply Tim.

I quite like the sound of defining a variable and setting that at run time. :w00t: I think I will investigate using a variable further. ...

any ideas welcome..........

andrius

thanks - I've now got it working (I had to remove the square brackets and also the " " in the dateadd statement.

Thanks a lot, this will be really useful.

Hi,

thanks for the post - I'm giving it a try but i'm getting an error:

Error Source: Microsoft Data Transformation Services (DTS) Package

Error Description: Error Code: 0

Error Source= Microsoft VBScript compilation...

just re-reading your message - did you add the name of the server before the server string in the table?

i.e.

Name (My Database Server)

Server (dbserver.network.com)

If you did, then what you...

it sounds like it's not picking up the server name correctly. Have you checked using watch variables and breakpoints that the servername is changing to the correct server string?

is send_email a predefined SQL2000 stored procedure?

1 other quick question - is send_email a stored procedure that I have to install / create or can I just call send_email.

Thanks

Hi Jerry,

I need to do it using SQL2000, so it would be DTS. I didn't realise it would be so simple.

I had an idea that it would invovle some...