Viewing 15 posts - 1 through 15 (of 321 total)
Sam Vanga (7/15/2015)
to know. In my experience, BidsHelper provides 100% support for...
July 16, 2015 at 4:31 am
g.britton (7/14/2015)
not sure what "use it in anger" means
Used something in a real world situation where the problem had to be solved as is and not a nicely tailored teaching...
July 15, 2015 at 5:16 am
I've used BIML for a large scale project before
~200+ ETL interfaces which included CSV, XML, Oracle etc...
My concerns are:
1. BIML might be free but to use it in anger...
July 14, 2015 at 6:27 am
Bulk loads are quickest for tables which are either empty or have no indexes.
If you are inserting a lot of data into an already large table then rebuilding the indexes...
March 27, 2015 at 5:46 am
Couple of points about this article
1. The Adventure Works Multidimensional Model Project needs to be downloaded (http://msftdbprodsamples.codeplex.com/releases/view/55330). Would be nice if the article was updated to reflect this.
2....
March 14, 2015 at 10:04 am
Another fantastic data mining article!
March 5, 2015 at 9:34 am
change the line
if(data[0] == filter)
to
if(data[0].Contains(filter))
The search expression will not need an asterix (*).
February 5, 2015 at 6:59 am
KoldCoffee (2/1/2015)
Samuel......
Can you...
February 2, 2015 at 6:46 am
KoldCoffee (1/28/2015)
Cannot apply indexing with [] to an expression type Microsoft. SQLServer.Dts.Runtime.Variables
I've never seen that before, Doing some research it seems to be an issue if you have multiple...
January 29, 2015 at 3:58 am
I have to ask this....
Why are you creating a brand new VM?
Surely one of the key use cases for Virtual Machines is that you can copy the VM in its...
January 27, 2015 at 1:08 pm
The best approach for this is to leave SharePoint as it is. There are good reasons for SharePoint being set up to not save files to a directory.
If you want...
January 27, 2015 at 4:02 am
KoldCoffee (1/22/2015)
That's awesome you did that. I've opened it and I will try it today.
no probs
I should have pointed out that the file path is defined in the file connection...
January 22, 2015 at 4:08 pm
Koen Verbeeck (1/22/2015)
I think the spam filter removed it.
probably too many links.. I'm surprised that posts (especially by established members) are automatically deleted
here's the package again with out the reference...
January 22, 2015 at 11:34 am
I did reply with a package for you... not sure what happened to it
Sam
January 22, 2015 at 10:42 am
Log Parser was made for this sort of problem
Might be a bit of overkill if it's only a one off issue though!
https://technet.microsoft.com/en-gb/scriptcenter/dd919274.aspx
SQL Bits session on it here too:
https://sqlbits.com/Sessions/Event9/LogParser-quicker_than_SSIS_easier_than_BCP
January 22, 2015 at 6:35 am
Viewing 15 posts - 1 through 15 (of 321 total)