Dynamic File Name for XML Source

[mylittergmailcom]

How do I manage dynamic filenames for XML Source? I have seen som tutorial for flat files but nothing for XML Source. There has to be a way to load a xml-files with todays date as filename. In SSIS that is.

Thanks for yor time...

 

[MDXer]

I'm not sure about an xml specific method but after you have created your data source in the connection manager pane you select it and then in the properties panel you would enter an expression the expression would be for the connection string. You would create an expression that would evaluate to the filename.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[mylittergmailcom]

That goes for Flat File Connection but there is no XML Source Connection in the Connection Manager. There is no expression option in the properties panel for XML Source.

Any other ideas?

Thanks for your time.

 

[MDXer]

Use a Script task and create it as a datasource.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck