Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

can i use package parameter in data flow > destination > OpenRowset property  ( SSIS 2012)

Posted on 2016-09-21
1
26 Views
Last Modified: 2016-09-21
i figured out how to useparameters in connectors and in control flow but i am having problem with data flow destinations boxes.
attached picture shows best what i'm trying to do,  i'm such a noob i cant really describe it properly with words

thank you
open-row-set.jpg
0
Comment
Question by:wojtek gabrielli
1 Comment
 

Accepted Solution

by:
wojtek gabrielli earned 0 total points
ID: 41809733
found my answer !
few rows above was a access mode property, had to change it to "from varible"
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Sometimes, you need to use PIVOT in SSIS to ensure your data matches the output requirements of your users. So, what is PIVOT and what is SSIS and how can that help ? Firstly a quick explanation of those acronyms as described by Microsoft :   M…
This is my first ever Article on EE or elsewhere; therefore, please bear with me if I have some discrepancies in my writing. I read many articles and questions related to "how to pass values to SSIS packages at run-time?"  Hence, this common ques…
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question