Wrox Programmer Forums
|
BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2008 Integration Services by Brian Knight, Erik Veerman, Grant Dickinson, Douglas Hinson, Darren Herbold; ISBN: 9780470247952
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Microsoft SQL Server 2008 Integration Services ISBN: 978-0-470-24795-2 section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old February 4th, 2010, 05:54 PM
Registered User
 
Join Date: Feb 2010
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connect to XML configuration file using C#

Hi
I am on SSIS 2008 and I created 2 XML configuration files with OLEDB connection name 'ServerConnections' on the package and I need to use C# to call it. follow by I placed these 2 XML configuration files on A and B SSIS servers on their local E:\Conn folder and in the config files XML Data source I have confgured the A SISIS server to Development SQL server and B SISS server to production SQL server. On my work station the package that I have using the Script Task I tried to execute a store procedure but how can I call the XML configuration file with the OLEDB package connection string 'ServerConnections' using C#? Any ideas? Thanks.





Similar Threads
Thread Thread Starter Forum Replies Last Post
XML ASP Configuration danishibu XML 3 November 6th, 2007 04:30 PM
Access / Modify Configuration File prasanna.nadgir C# 2 October 2nd, 2007 12:14 PM
how to connect xml file to webgrid of infragistics it_ashu2004 ASP.NET 1.0 and 1.1 Professional 0 March 25th, 2007 07:49 AM
Application Configuration File Bob Bedell C# 1 October 7th, 2006 10:56 PM
Configuration file name and location TomH VB Databases Basics 2 September 29th, 2006 06:59 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.