SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic

#1

In my OLEDB Destination Object in my SQL Server 2005 SSIS package, there is a
custom property call OpenRowset. I have a need to set this property
dynamically so it can run in several environments. I have done this method
with other properties, such as with connection strings, using the
configuration file. The problem is that the configuration file does not
expose the property. Has anybody else had a similar issue..?

#2

Use Variables concept.Declare variable, configure it through SSIS configuration.
selece data access mode in oled db destination as "Table or view name variable - fast load" or "Table or view name variable" and next select the new create variable in Variable Name drop down list.Let me know if you have any doubts.

Quote:

On Friday, October 27, 2006 8:00 PM dan.billow.remov wrote:

In my OLEDB Destination Object in my SQL Server 2005 SSIS package, there is a
custom property call OpenRowset. I have a need to set this property
dynamically so it can run in several environments. I have done this method
with other properties, such as with connection strings, using the
configuration file. The problem is that the configuration file does not
expose the property. Has anybody else had a similar issue..?

#3

On Mar 28, 5:08*am, Chetan Kumar <chetan.gopin... (AT) gmail (DOT) com> wrote:

Quote:

Use Variables concept.Declare variable, configure it through SSIS configuration.
selece data access mode in oled db destination as "Table or view name variable - fast load" or "Table or view name variable" and next select the newcreate variable in Variable Name drop down list.Let me know if you have any doubts.

On Friday, October 27, 2006 8:00 PM dan.billow.remov wrote:
In my OLEDB Destination Object in my SQL Server 2005 SSIS package, there is a
custom property call OpenRowset. *I have a need to set this property
dynamically so it can run in several environments. *I have done this method
with other properties, such as with connection strings, using the
configuration file. *The problem is that the configuration file does not
expose the property. *Has anybody else had a similar issue..?- Hide quoted text -

- Show quoted text -

The same is not working since. Error - "A Destination table has not
been provided "

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

SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic

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

SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic - 10-27-2006 , 07:00 PM

Re: SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic - 03-28-2011 , 04:08 AM

Re: SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic - 05-17-2011 , 04:43 AM