Dear SSIS experts,
I was wondering if there's such a thing that we could assign the database connection on the fly dynamically? so that I save the connection string or the database name somewhere and SSIS reads it on load time or something..
Thank you
Yes! Look into "package configurations." Examples and more information are in BOL and all over this forum.|||Thanks for ur quick reply; however, I can't find a thing! would u plz give me a link or something? Thanks
|||Pull up Google and type in (without the quotes) "ssis package configurations"The first few links should work very nicely for you.
The official page from Microsoft: http://msdn2.microsoft.com/en-us/library/ms141682.aspx
No comments:
Post a Comment