Viewing 15 posts - 10,036 through 10,050 (of 13,874 total)
Excellent - now follow part (3) of my advice. Edit your Excel connection manager (not the Excel destination) and open up the Expressions property.
Create an expression for the ExcelFilePath property...
March 28, 2013 at 8:03 am
kpann (3/28/2013)
I appreciate your response but do you think you could give me an example in your package? Do you think that ExcelFilePath will change dynamically for every iteration?
Sorry, don't...
March 28, 2013 at 6:44 am
Koen Verbeeck (3/28/2013)
At least, if the destination table isn't too large.
If there can be duplicate IDs in the source data file, it means the lookup has to be used in...
March 28, 2013 at 4:19 am
sumit.joshij (3/28/2013)
This scenerio is also called as Upsert Pattern.
/
Not really - as no updates are required here, I would call it a conditional INSERT.
March 28, 2013 at 4:04 am
This might work ...
1) Create a string package-scoped variable called ExcelFilePath (this will correspond with the ExcelFilePath property of your Excel destination)
2) Use a script task in your Foreach loop...
March 28, 2013 at 3:13 am
I'd do it like this:
1) Inside the dataflow, add a lookup. Configure the lookup to redirect on no match (rather than failing).
2) Use the lookup to check whether the input...
March 28, 2013 at 2:59 am
Cindy Conway-312336 (3/28/2013)
That being the case, why doesn't...
March 28, 2013 at 2:54 am
sonalijain.engg (3/27/2013)
March 27, 2013 at 2:07 pm
devilsid (3/26/2013)
March 27, 2013 at 2:19 am
Welcome to the forum Henry.
As this is quite an involved problem, may I suggest that you check out the link in my signature and then post some consumable DDL and...
March 27, 2013 at 2:09 am
jezza101 (3/26/2013)
Very interested to see the recursive CTE solution as that is what I've been trying to get going most of this morning! I wasn't...
March 26, 2013 at 10:25 am
Another version:
declare @t table
(
SaleId int
,Discount int
,Sequence int
)
insert @t (SaleId, Discount, Sequence)
select 1,15,1
union all
...
March 26, 2013 at 9:57 am
Love & Peace (3/26/2013)
Hi Phil,Thank you for giving me direction.
I figured out the answer for the second part of the question.
Excellent - so everything...
March 26, 2013 at 7:12 am
Love & Peace (3/25/2013)
Hi Phil,The output columns are actually different.
They vary by proc.
Thank you !
But you want them all in the same file - presumably, then, with new column...
March 25, 2013 at 12:13 pm
Are the output columns always the same, or do they vary by proc?
March 25, 2013 at 12:02 pm
Viewing 15 posts - 10,036 through 10,050 (of 13,874 total)