Viewing 15 posts - 10,036 through 10,050 (of 13,879 total)
I'm not sure about best practice, but as SSIS is so heavily dependent on design-time meta data, I try to avoid run-time meta-data tweaks where I can. I don't know...
April 1, 2013 at 8:08 am
Try adding a data viewer to ensure that the data values are exactly as you mentioned. Remember that you need to be case specific (I think). Leading or trailing spaces...
April 1, 2013 at 5:27 am
An alternative way of achieving is to leave the name of the Excel destination static, and to use the File System task immediately after the data flow to copy the...
April 1, 2013 at 1:04 am
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
Viewing 15 posts - 10,036 through 10,050 (of 13,879 total)