In the SQL statement Task use a ? in the where clause. Then click on the parameters button to map this to a global variable. Once the Global Variable has...

Had assumed it would be somewhere logical like a right-click on the fact table, and the OLAP books I've got mention refreshing of data, not new fields so I was...

Bob,

could you list some of the counters you're using - it may be that the ones you need aren't enabled by default eg Network Segment:Network Utilisation requires the installation of...

Works perfectly - thanks Skip.

Paul Ibison

Paul.Ibison@btinternet.com

Phred,

strange - even with your revised syntax I still get the message "Cannot use text, ntext, or image columns in the 'inserted' and 'deleted' tables.".

So, I'd decide to use...

My trigger should have been:

set @PhotoState = (select case when inserted.large_photo is null then NULL else '1' end

+ case when inserted.medium_photo2 is null then NULL else '2' end

+ case when...

Being from London like Duncan, I've been keeping a close eye on the UK job market. I get the impression that there is little requirement to have a MCDBA,MCSE or...

phred,

here's an insert/update trigger for you - (will leave you to create the corresponding delete one!)

CREATE TRIGGER photo_numbers

ON mls_photo

FOR INSERT , UPDATE

as

declare @PhotoState varchar(20)

set @PhotoState = case...

If you can't use /A due to sql 7.0 constraints, I'd go back to running the dts package as a job (2). Also, I'd use Andy's idea and write the...

Could try a couple of things to narrow it down. In the executesql task, or the first task in the package, look at workflowproperties/options/UseActiveX Script. Send out the value of...

Holly, could you post up the full command line you're sending so I can mimic it on my system. Also, how are you calling DTSRUN: from a cmdexec window on...

There are several solutions I can think of:

(1) You can use the sp_OACreate etc stored procedures. There is an article in Peterson's SQL Server 2000 DTS for this. Basically you...

phred,

this code below works ok and is a shortened version to do what you want. However, it has dbo as owner of the tables, so I think the problem may...

Can you post up your table definitions - I can look at it later if it's still not solved by then.

Paul Ibison

Paul.Ibison@btinternet.com

Phred,

my solution is not so bad as it seems. Ignore the Select - that was for illustration - this code can be used as a computed column. However, admittedly the...