Yeah, you'll need a MultiFile Connection Manager, the connection string of which is set by an expression. That expression should evaluate to "Bob_20060605*.bak"

You said you didn't want links unless they...

I don't really understand what you mean. You are quite able to build what I have suggested above and then schedule it. What comparison are you going to be making?

-Jamie

I think you might be approaching this the wrong way. For a start, you shouldn't try to affect a package variable anyway because even if it worked, only the value...

This should do it for you: http://blogs.conchango.com/jamiethomson/archive/2006/05/31/4009.aspx

You should be able to adapt this easily so as to pass in all your symbols. Good luck!!

-Jamie

Bill,

Hopefully this will answer your question: http://blogs.conchango.com/jamiethomson/archive/2006/05/23/3984.aspx

"these two types of output columns?"

External columns are not output columns - its important to realise that!

-Jamie

Alex,

I can repro the problem and I think is a bug. I've added a bug report here: http://lab.msdn.microsoft.com/productfeedback/viewfeedback.aspx?feedbackid=08bbef21-d05c-434e-82d8-5314c8f4959e

Please feel free to vote for it and/or add a comment.

-Jamie

Alex,

I've never seen these problems with the recordset destination though I dare say I've maybe never used strings in this way. Can you post a repro - perhaps against AdventureWorks...

All here: http://sqljunkies.com/WebLog/ashvinis/archive/2005/05/25/15653.aspx

-Jamie

David,

Chris Webb has pondered a bit about it here: http://spaces.msn.com/cwebbbi/blog/cns!7B84B0F2C239489A!559.entry

and I was speaking to a guy I know at on the SQL Server team in Redmond a few weeks ago and...

Regarding querying the data like Steve mentioned...i'd be interested as to whether this is within the capabilities of Analysis Services or not.

Its a shame that there aren't TPC multidimensional DB benchmarks as...

Strange!

I can only guess at a faulty install. Sorry I can't help more!

-Jamie

OK cool. And can you find "MsDtsSrvr.ini.xml"? if its not there then something is amiss - perhaps a faulty install??? I'm afraid I don't have the answer.

-Jamie

Being able to use BIDS does NOT mean that SSIS is installed. BIDS gets installed when you select the Client Tools option during install. SSIS is a seperate option.

Do a search...

Patrick,

If the file (MsDtsSrvr.ini.xml) isn't where Kirk's blog post says it should be then you haven't installed SSIS.

-Jamie

Ryan,

I'm keen to know if Robert's suggested fix worked for you.

-Jamie