Edition upgrade was the way I was trying to go and it just errors when I put the product key in. Bit of a pain!

I really dont want to wipe...

Will give it a go. I just wondered if there was any known reason why a valid product key would not be accepted

Thanks

E

Found the answer. The SQL statement was retrieved via a stored proc that replaced the string '[DATECHNAGED]' with last months date.

Bangs head on Wall

Thanks

I started looking through the packages again and noticed a difference with this package.

While looking back for this package I checked a few others. This one is different

In...

Nope,

STEP 1

In the Variables for the package there is a variable that holds the string SELECT ID ,Description FROM MyTable WHERE LastUpdatedDate >= '[DateChanged]'

STEP 2

Then there is an execute...

Ran the package with a breakpoint before the dataflow task. Now the SQL it picks up from our SQL table is "SELECT ID ,Description FROM MyTable WHERE LastUpdatedDate >= '[DateChanged]'"

but...

Phil,

this probably is harder to describe by writing than showing. The SQL for the OLE DB Source is a variable (not using expressions just hard coded) AS

SELECT ID ,Description...

Oh and another thing. When opened in BIDS the OLE DB Source will error as it compares a date to the string '[CHANGEDATE]'

But run by the parent package and there...

Many thanks for the help. I had forgotten about Olla's scripts.

Cheers

E

Phew.

Looked like dropping the extension worked.

Cheers

E

Looks like I need to add MSDB at the beginning of the target path. Now its complaining a selection of characters in the name is wrong. When placing in the...

That's kind of where I was thinking the issue could be. However as the is is 32 bits and I am opening them on the server which is 32 bits...

This does seem to offer me a chance of achieving what I want. The SMDL when imported creates the model and dsv. From looking at the DSV in notepad you...

Thanks.

So that's given me two .rds files (which are the data sources) and one report. I am glad I can get the report down! However the data sources seem odd...

Wow,

I really seem to have drawn a blank on this. I can see that downloading and uploading Models is possible. But it looks like BIDS needs data source, data source...