Viewing 15 posts - 11,401 through 11,415 (of 13,860 total)
I'll second that - a simple method which avoids sending unwanted data across the network.
May 17, 2011 at 5:57 am
You can do it in a single package - but you'll need 2 dataflows and some precedence logic to control which is executed. You may also have to set delayvalidation...
May 17, 2011 at 5:47 am
SSIS can't easily accommodate this sort of requirement. If it's only ever one of two formats, you'll just need two data sources and some conditional logic to force processing down...
May 16, 2011 at 2:11 pm
When it come to mapping of SSIS data type and SQL Server datatype then nchar, nvarchar, sql_variant, xml will be mapped directly to DT_WSTR (SSIS data type). Any mapping given...
May 16, 2011 at 7:33 am
Ninja's_RGR'us (5/16/2011)
Ho ya I remember reading something about that 4 years ago. Does the W stand for wide?
An excellent question and one which has just diverted me from my...
May 16, 2011 at 7:18 am
Ninja's_RGR'us (5/16/2011)
Anjan Wahwar (5/15/2011)
Convert to "Unicode String [DT_WSTR]" instead of [DT_STR]What's the difference between the 2? >>> never used ssis b4.
From BOL:
DT_STR
A null-terminated ANSI/MBCS character string with a...
May 16, 2011 at 6:58 am
c.jowett (5/16/2011)
May 16, 2011 at 4:45 am
The proposed solution does use sets - at least in the background.
May 13, 2011 at 3:41 am
Yeah, I agree - and there are plenty of RegEx examples available which would mean that it wouldn't take long to work out, even if you don't know.
But if the...
May 13, 2011 at 2:14 am
..could some sort of ascii range be used to include all letters of the alphabet?
Have you tried that? Something like (untested):
POLICY_ZIP >= "A0000" && POLICY_ZIP <= "ZZZZZ" ? "00000" :...
May 13, 2011 at 2:07 am
Damn right. I really feel like I'm doing valuable work when I'm chest deep in obtuse XML hierarchies.
Perhaps I should withdraw the post and take a few minutes to reflect...
May 12, 2011 at 9:58 am
Saying things like
However, I can see what the data looks like in the clients table when that happens.
is not very helpful to people who are trying to understand your requirements...
May 12, 2011 at 2:23 am
Presumably, there is other data on the lines with no dates which you want to keep? If so, you can't use Koen's solutions, as they'll discard the entire row.
From the...
May 11, 2011 at 2:17 am
kkupchyk 4137 (5/10/2011)
May 10, 2011 at 10:24 am
Not that I can think of, though there is more than one way of doing it:
1) In the SQL source.
This is probably where I would do it.
2) In SSIS -...
May 10, 2011 at 4:22 am
Viewing 15 posts - 11,401 through 11,415 (of 13,860 total)