Viewing 15 posts - 16 through 30 (of 114 total)
This link may be helpful:
http://richardlees.blogspot.com.au/2010/01/transaction-manager-is-not-available.html
June 5, 2012 at 6:02 pm
EDIT: Nevermind, posted in haste. Retain same connection is relevant to manual transactions.
Does it work when all your ExecSQLTasks are against the same server and only fail when you include...
June 5, 2012 at 5:27 pm
Koen Verbeeck (6/4/2012)
You'll need to use the SSIS transactions.
Is MSDTC running on every node and is it properly configured?
Regarding the lock, check if you don't have a deadlock somewhere.
Are you...
June 5, 2012 at 12:26 am
So we have:
A M:1 relationship from dimension to fact.
A dimension tracking events.
I'm getting a Mr Squiggle feeling here.
Your case events log table sounds an awful lot like a fact table....
June 5, 2012 at 12:01 am
You may want to look into a master data solution.
June 4, 2012 at 11:43 pm
I don't know how, or if, Itanium affects things. But I've done this on 2008 R2.
You can't call packages in 32 bit mode from a 64 bit execution. Not as...
May 15, 2012 at 7:45 pm
Daniel, I am grabbing a column from an independent source and trying to compare to a column coming from another server. How will this work given your advise?
This is exactly...
May 8, 2012 at 7:23 pm
herladygeekedness (5/4/2012)
If I had to float this for signoff indefinitely, I'd make an approval button that fires the partition switch step
^ This.
EDIT:
To elaborate: given the requirement to wait indefinately...
May 6, 2012 at 5:47 pm
Daniel Bowlin (5/3/2012)
I have an idea for a different approach. It would take a little effort to set up, but way easier than a parallel environment.
This is an interesting...
May 3, 2012 at 6:05 pm
Another interesting link: http://www.kimballgroup.com/html/designtipsPDF/DesignTips2005/DTKU74Compliance-EnabledDataWarehouses.pdf
without an audit log of some sort giving the old values, etc...
Yep, and there are, of course, a number of different ways to approach it.
e.g. Change updates...
May 2, 2012 at 7:41 pm
Personally, I like the Kimball suggestion of having a surrogate key on your fact table. If you log the surrogate keys included in each ETL batch this gives you a...
May 2, 2012 at 6:57 pm
hmm, maybe I was encountering tab characters. If the SQL trim removes tabs that would be consistent with what I saw.
April 19, 2012 at 12:23 am
I've seen different results when using trim in SSIS compared to trimming in a SQL statement.
As a matter of course now I use a script component to do my trimming...
April 19, 2012 at 12:14 am
Yes.
Oh, alright... 😛
How many rows are we talking about? How wide?
Is the destination on the same server as the source?
Some say that dumping the table into a flat file from...
April 12, 2012 at 6:44 pm
Viewing 15 posts - 16 through 30 (of 114 total)