hi Robert

a little trick to double up single quotes is to create a simple varchar @single_quotes then use this a wrapper around any string you want to double up...stops you...

hi robert,

Try something like this...quick and dirty (thats me...) ..use sp_executesql and a while loop

make up yr sql as a string and then execute it

something like this....back of a...

I had exactly the same problem...i had the dll in the privateassembly folder of c:\program files\microsoft visual studio 8\common7\ide\privateassemblies..it kept on giving the same error message as you have.

I trawled...

quick and dirty use sp_executesql

assuming months param @monthlist is entered with comma delimiter i.e 'Jan, Feb, Dec' or 'Jan'

somrting like this....

declare @sqlstring varchar(255)

SET @sqlstring = 'SELECT * FROM...

hi Koen/Gsquared

Sorry for not getting back to you...been away...first of all a "mickey mouse" package is just a test harness created to test out a concept....

The "on error" at the...

hi Trout,

I replied without checking the excellent article referenced above

http://samuelhaddad.com/2009/03/31/overwriting-an-excel-file-destination-using-ssis/

looks as if this kiddie answers all the work rounds...as i say mine was done as a quick...

hi Trout

What I did as a quick and dirty fix was to save the original spreadsheet (deleting the myView worksheet) as spreadsheet.xls.stru i.e as a template and in my...

hi Trout,

I am assuming you have created siss package to export to excel you are using the export wizard and you are then running this as a job. You might...

thanks Andy...I'll give it a go

attd is script i did for a database called yellowpages to add myself (robin) with readonly privileges

and execute permission on one stored proc from scratch...hope it helps...script is always...

hi aaron,

My experience is only down to using dates to the day level granularity and having a single date key column in my fact table.

From what i have read it...

hi Aaron,

What i did was to use the DimTime in AdventureWorks as a template and just added extra dates to it and then

it is always there as a static time...

many thanks Gethyn...so having sub plans is the trick i guess...will also read yr blog

hi Naveen

Yeah that works...thx you very much for yr assistance..much appreciated

hi Naveen,

[Calendar Years] is set to type "Years", YearMonths type is set to "Months" and [Year Month Days] is set to "Days" and the Time type was set...