Viewing 15 posts - 10,306 through 10,320 (of 11,676 total)
frank_suijkerbuijk (1/28/2011)
put as many transformations in the SQL iso a derived column
What if your source is a heavily used production system?
Will you burden it with extra transformations, or will you...
January 28, 2011 at 1:14 am
Nice question, really learned something.
The BOL page doesn't even mention this subject.
January 28, 2011 at 12:08 am
Oberion (1/27/2011)
where col1 is nulland col2 = ""
The original requirement was to check for the same column, not two different columns.
January 28, 2011 at 12:04 am
dennisparks (1/27/2011)
But if you suggest the database is not to format data nicely, why even have the convert, cast, substring, etc... functions??
I think CAST and CONVERT are more used to...
January 28, 2011 at 12:02 am
WayneS (1/27/2011)
(I just wish it worked the way I thought it did...)
I have that feeling alot when working with computers 😀
January 27, 2011 at 11:53 pm
WayneS (1/27/2011)
Which makes what I'm trying to do a PITA. 🙁
Pita?
http://upload.wikimedia.org/wikipedia/commons/5/5f/Pita_topped_with_artichoke_hummus_and_lamb.jpg
January 27, 2011 at 11:50 pm
dennisparks (1/27/2011)
Plus, the question reminds me of an episode of Whose line is it anyway where they do...
January 27, 2011 at 11:40 pm
If you have a 64-bit machine, you'll have two program folders:
one regular, for 64-bit programs and one called C:\Program Files (x86)\. That last one is for 32-bit programs.
Look for dtexec...
January 27, 2011 at 11:37 pm
Doesn't a DENY overrule the SELECT permission?
January 27, 2011 at 2:09 pm
jm99 (1/22/2011)
We're currently working on a data warehouse...
January 27, 2011 at 2:06 pm
CozyRoc (1/27/2011)
You have to use the standard 'Derived Column' transformation to transform the source columns into the appropriate destination column types.
Or if you have creating expressions in the Derived Column...
January 27, 2011 at 1:55 pm
You can't use the CAST and CONVERT commands in the SQL query to Excel, as the provider does not know those keywords. You can try FORMAT though (the Excel function).
IMEX=1...
January 27, 2011 at 1:50 pm
David Jahngir (1/27/2011)
SELECT DISTINCT
B12.MODLN_USC_C + ';' +
LEFT(ENT_ENTITY_C, 1) +
SUBSTRING(ENT_ENTITY_C, 3,...
January 27, 2011 at 1:45 pm
siluctc (1/27/2011)
5. Use parallel execution.
Will this always improve package performance?
Please elaborate...
January 27, 2011 at 1:43 pm
Elliott Whitlow (1/27/2011)
January 27, 2011 at 1:41 pm
Viewing 15 posts - 10,306 through 10,320 (of 11,676 total)