| Computers Forum Index » Computer - Databases - MS SQL Server » Can you retrieve SSIS config values from XML stored in... |
|
Page 1 of 1 |
|
| Author |
Message |
| Thomas R. Hummel... |
 Posted: Tue Oct 20, 2009 2:47 pm |
|
|
|
Guest
|
My current client stores all of their configuration information for
the enterprise applications in a single table that holds XML. They
then use a custom built front end to maintain the configuration
values.
I'm writing a fairly straight-forward import process for them using
SSIS. I need to make the connection strings and some other information
configurable and they want me to use their table. It seems like SSIS
expects a file though. Is there any way that I can point SSIS to
retrieve its configuration values from an XML stream instead of a path
to a file?
The configuration table that they use does not match the structure of
a standard SSIS configuration table that you would get using SQL
Server as a configuration source with the standard wizard.
Thanks for any advice!
-Tom. |
|
|
| Back to top |
|
|
|
|
