Eric Hobbs (7/13/2012)

---

Also once you run the package using the SSIS 2008 package execution tool, it will upgrade the package on the 2005 server, so you won't be able to...

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...

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...

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...

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...

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...

No problem, just trying to save you sone grief!

good luck with SSIS, and have fun...

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...

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...

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...

What data type is [col1], what possible values are in [col1], and are you creating a new column?

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...

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 few variables, and a...

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...

100*2.75/(1-0.32)