Viewing 15 posts - 1 through 15 (of 50 total)
Eric Hobbs (7/13/2012)
July 13, 2012 at 8:21 am
Are these file caches, or memory caches?
From what I recall, you won't be able to make them work unless they're file caches...
What error messages, etc. do you get when "it...
June 4, 2012 at 12:51 pm
You really should be creating an XML file per Connection. Yes - just one property per connection file. That way, if you have four connections that you regularly...
September 19, 2011 at 5:10 pm
It doesn't work quite like you're describing.
What happens is that the CreateNewOutputRows method adds each row, one at a time, to a set of rows called a buffer of a...
August 22, 2011 at 10:58 am
That's too bad - I thought they'd squashed that bug in 2008.
Try one of the other two workarounds - like collapsing the "depth" of the expressions, or using a Script...
August 5, 2011 at 12:23 pm
Can I hazard a guess?
You're using SSIS 2005, and the DateStamp string variable is built using an expression off of other variables...
If that's the case - yep, it's what I'd...
August 5, 2011 at 10:24 am
No problem, just trying to save you sone grief!
good luck with SSIS, and have fun...
July 7, 2011 at 2:54 am
The delay is caused by the lookups caching your dimension table data. You'll be able to see this by running Profiler, PerfMon, etc...
To optimize your lookups, make sure you're...
July 6, 2011 at 11:06 am
I think a terminology mistake is causing these replies.
You don't have "50 flows" in your data flow, you have 50 components.
50 "flows" in one Data Flow Task is downright bad...
July 6, 2011 at 11:02 am
I don't quite understand what you're describing - but there are differences in how 2008 applies package configurations versus how 2005 did it. You should read Dougbert's blog post...
May 30, 2011 at 10:27 am
What data type is [col1], what possible values are in [col1], and are you creating a new column?
May 16, 2011 at 9:48 am
See if there are any messages in the Job Step History - there should be.
You should also turn on Package Logging and enable Errors, Warnings, and other events to be...
May 7, 2011 at 9:41 am
You can use Script code available here: http://ssisctc.codeplex.com/wikipage?title=Script%20Task%3a%20File%20Properties&referringTitle=Home
Or the File Properties Task available here: http://filepropertiestask.codeplex.com/
Either of those inside a Foreach Loop with a File enumerator, a...
April 29, 2011 at 4:47 pm
Are you talking about "interactive" execution? If so, create a new Integration Services project in VS2008, right-click on the packages node, and select "Add Existing Package". You will...
April 27, 2011 at 2:47 pm
Viewing 15 posts - 1 through 15 (of 50 total)