Viewing 15 posts - 31 through 45 (of 321 total)
I created something similar in .NET recently for SSIS 2008 as part of a Masters project. It basically encapsulated and simplified the access to the SSIS object model allowing packages...
July 18, 2013 at 3:52 am
I think the use of Machine Learning in ETL systems needs to be a bit more subtle than formatting errors. Formatting and data errors are easy enough to pick up...
June 12, 2013 at 2:51 am
When working in Tabular mode you need to move away from the concept of fact and dimension tables. Each of those joins will require an index creating on each table...
March 20, 2013 at 9:46 am
Hi Arun
Nice walk through on how to use SSIS for shredding XML sources, I usually prefer to use SQL (Example below) but as it's not always possible to use ones...
February 27, 2013 at 6:01 am
John.Sansom (7/19/2012)
Contrary to your own apparent success, perhaps consider why play a numbers game, taking the unnecessary risk of being overlooked, when a targeted resume will consistently come out on...
July 19, 2012 at 10:16 am
Koen Verbeeck (7/19/2012)
I'm thinking what John meant was that it's for example not necessary to put "I've done some PHP development in college" on your resume when you're applying for...
July 19, 2012 at 4:54 am
With regards to the relevancy and a "catch all" resume..
I've been using a catch all for the past 6 years as a contractor and I've never been out of work...
July 19, 2012 at 4:23 am
Koen Verbeeck (6/13/2012)
Ah ok, so you didn't mean improve but reduce 😉
Sorry for the confusion <insert sarcastic comment about improving memory usage so it uses more /> 😀
Koen Verbeeck (6/13/2012)
June 13, 2012 at 2:45 am
Koen Verbeeck (6/13/2012)
It seems odd BIDS needs 1.5Gb for that. On the other...
June 13, 2012 at 1:56 am
I know for a fact that a master package can instantiate multiple instances of the same child package.
I guess the tough bit to work out is how to pass the...
June 12, 2012 at 2:51 pm
CELKO (2/11/2012)
>> A huge assumption and very condescending! <It was neither.
It was, end of story
February 12, 2012 at 4:07 pm
GSquared (2/9/2012)
February 10, 2012 at 5:58 am
SQL Kiwi (2/9/2012)
February 9, 2012 at 5:33 am
jcb (2/9/2012)
It can be achieved from many ways and for dynamic arrays we can use any kind of split function and strings.
But I miss the simplicy arrays can give...
February 9, 2012 at 4:39 am
jcb (2/9/2012)
I miss arrays a lot in SQL. Like this:
create procedure ImissArrayParam(@array Array(Integer))
as
begin
select * from myTable where myId in @array
end
GO
you can do this:
CREATE TYPE DemoTableType AS TABLE
( ...
February 9, 2012 at 4:18 am
Viewing 15 posts - 31 through 45 (of 321 total)