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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 28, 2011 at 1:14 am
Nice question, really learned something.
The BOL page doesn't even mention this subject.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2011 at 11:37 pm
Doesn't a DENY overrule the SELECT permission?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2011 at 2:09 pm
jm99 (1/22/2011)
We're currently working on a data warehouse...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
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,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2011 at 1:45 pm
siluctc (1/27/2011)
5. Use parallel execution.
Will this always improve package performance?
Please elaborate...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2011 at 1:43 pm
Elliott Whitlow (1/27/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
January 27, 2011 at 1:41 pm
Viewing 15 posts - 10,306 through 10,320 (of 11,676 total)