Viewing 15 posts - 4,636 through 4,650 (of 11,676 total)
Yes, but I would install the Developer edition, unless you have too much money to spare 🙂
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2013 at 4:47 am
Basically you'll want to avoid the sort and aggregation transform in SSIS; as they are blocking transformations and load all rows into memory.
These types of transformations are better handled by...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2013 at 4:34 am
etl.laptop (10/3/2013)
Koen Verbeeck (10/3/2013)
This made it seem that SSIS will go to "my Package" (how does it find the package to go to is another question), that is the Package.dtsx...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2013 at 3:44 am
etl.laptop (10/3/2013)
Koen Verbeeck (10/3/2013)
There's a book, but it's about scripting in SSIS 2005, so it is all Visual Basic.
Okay, so will this...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2013 at 3:37 am
Easy one thanks!
(it's also the only useful new feature in SQL 2014 so far)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 4, 2013 at 3:06 am
There's a training kit available for that exam.
I didn't read it though. I did the exam in beta, so I didn't have any official preparation materials.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 3:24 pm
* ConfiguredType=Property. This tells the configuration configures a property of some object.
* Path is some sort of location of the object you which to configure.
For example: "\Package.Connections[AdventureWorks].Properties[ServerName]"
You take the package,...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 3:22 pm
I went through a full fledged C# book, and it was useless.
In SSIS, 95% of the time you really need basic scripting:
* handling files/directories
* read/ write to a file
* regular...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 3:12 pm
Are you sure it works fine? You have a whole lot of blocking transformations in your package, which can lead to serious performance issues for large data sets.
Anyway, on topic:...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 2:06 pm
There's a book, but it's about scripting in SSIS 2005, so it is all Visual Basic.
The Rational Guide to Extending SSIS 2005 with Script
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 1:59 pm
etl.laptop (10/3/2013)
Looking at the future and other applications of those programming languages, I wouldn't waste my time with VB, but start with C#.
I don't understand what do you mean by...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 1:48 pm
I can see it on my mobile and from home, so it might be some company firewall issue.
Although I have noticed other users complaining about avatars as well.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 1:46 pm
WayneS (10/3/2013)
Who is going to the Summit this year? (I need to figure out who to meet up with...)
I won't be coming. Don't cry, my time will come. (someday...)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 12:22 pm
Shaun2012 (10/3/2013)
I am getting all the data, in my text qualifier i had "_x003C_none_x003E_" which i removed it but can anyone tell what does do..in the text quliafier"_x003C_none_x003E_".
regards
Shaun
For some...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 11:24 am
Brandie Tarvin (10/3/2013)
Jeff Moden (10/3/2013)
Lynn Pettis (10/3/2013)
enriquezreyjoseph (10/2/2013)
Jeff Moden (10/2/2013)
enriquezreyjoseph (10/1/2013)
Is this right if i will do my project this way?
Please see...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 3, 2013 at 11:21 am
Viewing 15 posts - 4,636 through 4,650 (of 11,676 total)