Viewing 15 posts - 1 through 15 (of 29 total)
Nice article. I did a similar thing a few years ago using shared schedules. Avoids hard coding the GUID into stored procs.
I wrote it as one big mad post on...
March 20, 2013 at 6:30 am
If you serialise the packages, you get a big performance hit as each one has to wait till the preceding one completes.
A better method for fast loading is to logically...
August 5, 2011 at 9:14 am
SSIS is fantastic for writing data pump architecture (static colum setup, changable row volume and values), but if the columns info changes it does cause it all to grind to...
August 5, 2011 at 9:04 am
I like that metaphor. rofl.
The biz always errs on the side of caution, that's why its easy to predict what they will say!! 😀
July 30, 2011 at 6:47 am
Funnily enough that is how we left it, With the analyst to go back to the biz to see how important history is for this.
I suspect the answer will...
July 29, 2011 at 12:51 pm
I'd get on to the numptie that decided to put three types of data in a random fashion into a flat file.. give em a quick kick and get them...
March 1, 2011 at 9:31 am
imani_technology (2/28/2011)
March 1, 2011 at 9:23 am
michael.french 172 (2/23/2011)
When the data source is configured, there is an option in the All tab of the Connection Manager. It gave pooling options, so I select ResourcePooling instead of...
March 1, 2011 at 7:54 am
I'm having a simliar issue also with 2008R2 SSIS.
master package that calls 6 children (in series) to load data into an oracle db using attunity drivers.
At random intervals one of...
February 9, 2011 at 4:41 am
I think the most interesting error there has to be the "SQL Server Network Interfaces: The clocks on the client and server machines are skewed." , I'd troubleshoot the...
February 9, 2011 at 3:16 am
I take it your talking about the KimballSCD from codeplex and not the standard one in SSIS ? If I have source data from multiple sources I stage it into...
February 9, 2011 at 3:06 am
Hi,
I've been having a simliar issue on our production box recently, an etl solution that uses sql2008r2 ssis/rdbms to load data into an oracle 10g database. In production the daily...
October 19, 2010 at 4:05 pm
We are upgrading to SQL 2008 R2. I've just tried setting this up as per 2005 instructions above and it works just fine , no changes required at all 😛
joy!
July 27, 2010 at 8:55 am
😛 heeheee ahh ever changing sands farkin up the troubleshooting!!
October 16, 2009 at 8:33 am
Viewing 15 posts - 1 through 15 (of 29 total)