Viewing 15 posts - 10,036 through 10,050 (of 13,876 total)
Without actually setting this up for myself, I am not sure how much more help I can offer.
Do all of the spreadshhet files already exist?
Have you tried using breakpoints to...
March 28, 2013 at 12:29 pm
I'm using 2012 - maybe it's different if you are on an earlier version - hopefully it should be obvious, if you already have a connection configured.
March 28, 2013 at 8:11 am
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
Viewing 15 posts - 10,036 through 10,050 (of 13,876 total)