Viewing 15 posts - 10,891 through 10,905 (of 13,872 total)
Koen Verbeeck (2/8/2012)
Phil Parkin (2/8/2012)
Koen Verbeeck (2/8/2012)
banu2316 (2/7/2012)
findstring(character expression,string,occurance)!=-1wat does the condition specifies here.
That's a tautology (aka always true).
-1 is never returned by the findstring function, so this expression always...
February 8, 2012 at 2:19 am
Koen Verbeeck (2/8/2012)
banu2316 (2/7/2012)
findstring(character expression,string,occurance)!=-1wat does the condition specifies here.
That's a tautology (aka always true).
-1 is never returned by the findstring function, so this expression always yields true.
Actually, I think...
February 8, 2012 at 1:20 am
I'm guessing that this is a simplified version of what you are trying to do - so we run the risk of my answer not being sufficient for your real...
February 7, 2012 at 3:41 pm
Or configure your source comnection to use a query and bring in the name column there - that's probably what I would do.
February 7, 2012 at 1:30 am
quillis131 (2/6/2012)
Koen Verbeeck (2/6/2012)
What exactly do you mean with a file?A database table, or an actual file, such as a flat file (.csv)?
Looking for downloading a file (.XYZ extension) from...
February 6, 2012 at 12:47 pm
Thanks for the response. I got there in the end by a slightly devious method - I did an alter table with nocheck and added a Check constraint on the...
February 6, 2012 at 10:58 am
Certainly can't put together some sort of sql that can think
Come on Sean, don't let the side down, that should be easy for you :w00t:
February 6, 2012 at 10:33 am
mmiller 85218 (2/6/2012)
I need results as they show in my first post. So the actual combination of the different possiblities.
Your earlier post states this:
Ok, so lets assume that CatID...
February 6, 2012 at 9:45 am
CozyRoc (2/6/2012)
Shaheen,I will leave the translation of the code from VB.NET to C# to you. The code is very similar.
February 6, 2012 at 7:55 am
Is this a school project or something?
Whoever made that requirement needs to justify it.
February 6, 2012 at 2:41 am
nhimabindhu (2/6/2012)
without using the query .Means using oledb source and aggregate tranfomations i need to send to destination .Not using that query in execute task or in oledb source
Please explain...
February 6, 2012 at 2:31 am
Thank you very much for the responses - I'll look into the partition switching idea.
Phil
February 2, 2012 at 11:08 am
Gazareth (2/2/2012)
Although if you're doing all that, I wonder why SSIS would be used at all in this case.
Surely at that point SSIS has...
February 2, 2012 at 7:03 am
Koen Verbeeck (2/2/2012)
Phil Parkin (2/2/2012)
There's no such thing as reusable functions in SSIS ...
That's not quite true, though it certainly isn't as easy as it might be. If you...
February 2, 2012 at 7:01 am
Viewing 15 posts - 10,891 through 10,905 (of 13,872 total)