Thank you so much for your xml function, i am getting an error The replace function requires 3 argument(s)

thank you, what do you mean with a CTE, in my case i will use this function for a variable (int) , i don' think its necessary to create a...

i have my package in my sql server in integration services. in the MSDB, under a folder called application packages.

hi i am using your code in the command line

'C:\Progra~2\Micros~2\90\DTS\Binn\DTExec.exe /dts "\Application Packages\MyPackage.dtsx"'

but i keep getting this error:

The process could not be created for step 1 of job...

what parameters should i use for the tally table? can i do it without creating one?

Hi! to answer my own problem, i changed the application pool to use the Default application pool instead of the reporting services application pool and voila! problems solved. 😀

thank you!, both functions would do the same as using unpivot?

can you please explain to me a little bit more about the pivot function and how can i use it in this case?

wow! thanks i will go ahead and test it thank you so much.

thank you!!!

yes, i have a table which has the changes in sizes of all my databases, for the last 3 months, for the whole amount of diskspace i have in my...

yes!!! , thank you all :), does partitioning come into play when deciding how much diskspace is needed?

got it thanks!

i tried it but i got this error:

'dtsglobalvariables' is not a recognized built-in function name.

Thank you all! i upgraded to sp2 successfully. 😀