SSIS OLE DB Destination

#1

Is it possible to set the Connection manatger's Server Name dynamically. For
Example i am exporting data from a SQL server to a MS access File. I need to
change the name of the access file i am exporting data to , dynamically.

#2

Hello Ram,

Yep.

Have a look at Property Expressions on the Connection manager.

You can either do it like this or you can use Configurations.

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Is it possible to set the Connection manatger's Server Name
dynamically. For Example i am exporting data from a SQL server to a MS
access File. I need to change the name of the access file i am
exporting data to , dynamically.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

SSIS OLE DB Destination

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

SSIS OLE DB Destination - 04-13-2006 , 01:29 PM

Re: SSIS OLE DB Destination - 04-13-2006 , 08:55 PM