Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9
This is the forum to discuss the Wrox book Professional SQL Server 2005 Integration Services by Brian Knight, Allan Mitchell, Darren Green, Douglas Hinson, Kathi Kellenberger, Andy Leonard, Erik Veerman, Jason Gerard, Haidong Ji, Mike Murphy; ISBN: 9780764584350
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional SQL Server 2005 Integration Services ISBN: 0-7645-8435-9 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 July 6th, 2006, 07:17 PM
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 1
Thanks: 0
Thanked 0 Times in 0 Posts
Default Specify the connection string property at runtime

I would like to be able to specify the path and file name to a flat file source connection at run time from a VB.NET windows application which will then run the SSIS package.

I can open a common dialog box in VB and have the user select a text file to load. How do I pass this file path in to the SSIS package connection manager so it will be available to the flat file source in the Data Flow configuration?

I have a package running with a path and file name specified in the ConnectionString property. My question is how to change that property at or just before runtime.

Larry
 
Old July 7th, 2006, 09:40 AM
Registered User
 
Join Date: Jun 2006
Location: Genova, Italy, Italy.
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default

First you must create a package configuration (SSIS->PackageConfiguration -> add)
In the dialog box choose XML configuration, insert a name for destinatio n file, next.
Now, in the object list, you can choose all value do you want change at runtime, so you can go in connection and find your configuration manager.
select wich property do you want read at runtime.
save the package configuration

Now, with vb you can modify the file xml

by

abc




Similar Threads
Thread Thread Starter Forum Replies Last Post
Connection String setting at runtime TwoTrees BOOK: Professional ASP.NET 3.5 : in C# and VB ISBN: 978-0-470-18757-9 3 July 2nd, 2010 11:41 AM
ExecuteReader: Connection property has not been in Follie Visual Studio 2005 3 October 14th, 2008 04:06 AM
changing connection string at runtime kscase VB Databases Basics 2 July 3rd, 2007 10:47 AM
Connection property has not been initialized sasi.vempalli ASP.NET 1.0 and 1.1 Basics 0 September 19th, 2006 03:03 AM
Runtime property sonurijs ASP.NET 1.0 and 1.1 Professional 0 September 22nd, 2005 11:44 PM





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