Solved

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

Posted on 2016-09-21
1
23 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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
My client sends a request to me that they want me to load data, which will be returned by Web Service APIs, and do some transformation before importing to database. In this article, I will provide an approach to load data with Web Service Task and X…
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.
Although Jacob Bernoulli (1654-1705) has been credited as the creator of "Binomial Distribution Table", Gottfried Leibniz (1646-1716) did his dissertation on the subject in 1666; Leibniz you may recall is the co-inventor of "Calculus" and beat Isaac…

813 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now