No unfortunately. I don't think many people use this which is a shame as it's a nice function. I abandoned it in the end. Result is I have to write...

OK, many thanks. Will have to be done in bids then.

Thanks. Do you mean I can put the name of a stored procedure in the default value box for the date parameter?

Anyone use report builder for their users?

Oops! Doesn't look like my colour tags worked on this!!!

Forgot to add that I got this to work nicely. I used the sqlcmd command in the end. The syntax was as follows in the bat file (items in violet...

I've noticed this today. Very frustrating. Looks like a bug to me. However there is a way you can scroll down the full list of document map labels and that's...

Cool! I'll look that up to see how to run it.

I agree, but it's normally the lazy option! You do have more control over it if you set it all up yourself too.

I didn't work out a way of toggling both I'm afraid. Toggling views can be very troublesome I find. Something I've found recently is, if you've set up a report...

Doesn't look like many people use report builder & report models as I never seem to get a response on this front on this site, other sites, or through searching...

I've come across a few times before and trawled the net trying to find a way round it with no success. What I've found is easier than fiddling around with...

OK then, so a workaround within SSIS rather than a function of SSIS it sounds. Thanks for your assistance here Jeff.

Is there no way of doing what I'm trying to do with text files though?

Ok, thanks for your input here. I'll give that a go.