Viewing 15 posts - 10,111 through 10,125 (of 13,879 total)
Yeah that makes sense.
I don't think it matters much where you put it - maybe between (4) and (5) would work well.
Regarding the lookup itself - will there be an...
February 22, 2013 at 12:59 pm
Sounds like a textbook use for the lookup transformation to me - go for it.
Do you have specific questions about how to set things up?
February 22, 2013 at 12:43 pm
sameerarjuna (2/21/2013)
I have been reading books and reading online for the past few days and created a...
February 22, 2013 at 2:02 am
Debbie Edwards (2/21/2013)
My problem is that my folders arent on the C drive but...
February 21, 2013 at 6:46 am
mister.magoo (2/21/2013)
Phil Parkin (2/21/2013)
Alternatively, add a Conditional Split in the data flow and split the data into four streams - to four separate files.
I like this idea, but only if...
February 21, 2013 at 2:20 am
mister.magoo (2/20/2013)
Sorry, feeling a bit :hehe::w00t:
Truly...
Create a dates table (with weeks in it)
Add a...
February 21, 2013 at 2:09 am
I'd say that the first thing you should try is some query optimisation - maybe you can get the query running fast enough so that you don't need to do...
February 21, 2013 at 2:07 am
There are almost always alternatives, and knowing the pros and cons of each is a really useful thing. In this case, once data is in a staging table I would...
February 20, 2013 at 7:47 am
Resender (2/20/2013)
Tried that and it still executed the flat file destination
I did not say it wouldn't.
My suggestion is to perform the deletion as part of the control flow -...
February 20, 2013 at 7:43 am
Maybe you could come at this from another angle.
Why not put a rowcount transformation underneath the script component and then delete the file in the control flow if [rowcountvariable] ==...
February 20, 2013 at 7:09 am
Jacob Pressures (2/19/2013)
February 20, 2013 at 3:16 am
sunder.mekala (2/19/2013)
why 5 ole db sources?
As i dont...
February 19, 2013 at 11:33 am
sunder.mekala (2/19/2013)
FYI, No Sorting requirements, and flat file formatting is delimeter, Thanks.
I don't know what you mean when you say "..flat file formatting is delimeter," but from what I can...
February 19, 2013 at 10:43 am
Daniel Bowlin (2/19/2013)
How about1.2 - FLOOR(1.2)
Floor returns the largest integer that is less than or equal to the numeric expression
Not true for negatives. Try this:
select -11.2 - floor(-11.2)
But stick to...
February 19, 2013 at 8:36 am
Loads of examples of this all over the Internet, but try this for starters & see whether it helps.
February 19, 2013 at 6:47 am
Viewing 15 posts - 10,111 through 10,125 (of 13,879 total)