SQL 2005 SSIS Setting OLEDB connection OpenRowset property dynamic

Discussion in 'microsoft.public.sqlserver.dts' started by Alien2_51, Oct 28, 2006.

  1. Alien2_51

    Alien2_51 Guest

    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..?
    Alien2_51, Oct 28, 2006
    1. Advertisements

  2. Alien2_51

    Chetan Kumar Guest

    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.
    Chetan Kumar, Mar 28, 2011
    1. Advertisements

  3. Alien2_51

    prasad Guest

    The same is not working since. Error - "A Destination table has not
    been provided "
    prasad, May 17, 2011
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.