Check these out:

http://www.simple-talk.com/sql/sql-server-2005/dts-to-ssis-migration/

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/ff17cddd-e23f-4e06-aba2-e65d5d2d629d/

Yes thanks.

I couldn't find any examples other than -1 0 and 1. Thats good to know though- thanks.

Cheers dan - thats useful to know. I'm not yet MCITP, but I plan on taking the exam soon.

very basic overview:

A Cube can be best summed up as something you want to analyse e.g. Sales, Inventory

A Dimension is how you look (or from what side) you look at...

ok nice and simply add this list

Description,DeviceID,FreeSpace,Size,SystemName

to the read only variables under the Script section.

Once done - then the script should work.

Attached is a screen shot to show...

this document should better explain it.

Found the error!

On Page 2 of your PDF you show the Inputs and Ouputs.

The output name that you have called 'Output 0' is the problem. If you change this...

Could you check that you have done step 14. - (if I change my package to exclude these variable - I get an output buffer errror

14.Next, select Script...

Is it defined as a source --> I'm referring to when you add the script compenant task in step 12.

I'll see if I can spot anything else. Would a...

is it declared as a source?

also. did you define the output columns?

another thing - check that your script containers all the imports - if it doesn't then that could...

Excellent. I'm Pleased it worked.

I'm just returning the favour that many others have done me on this forumn.:D

OK,

hopefully I won;t miss anything, but I've attached a PDF (WMI QUERY Guide.pdf ) on how to do a WMI Query for server disk usage.

I think point 8 is probably...

hi thanks for the reply.

I think I should maybe have posted more detail. I am aware of the different package security levels.

What I have done is set the...

stumbled across this whilest looking for some Excel KPI tools etc...........

I have 2007 office installed, so this could explain why I had the formentioned problem.

http://office.microsoft.com/en-us/products/FX101633871033.aspx?ofcresset=1#9

Installing Office 2007 breaks certain functionality...

Thanks Dan.

I checked out the first forumn thread and for anyone with the same problem this was the answer:

Mary Potapova - Posted on 25 September 2006 19:08:39

hello,

this might be...