Jim Murphy (5/10/2011)

---

Koen Verbeeck (5/9/2011)

---

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals...

You can combine flows in the dataflow using the UNION component.

But why are you calculating the next sequence number? Can't you use an IDENTITY constraint in your destination table?

If this...

Nice and easy, thanks.

I was looking for a gotcha, but couldn't really find one.

I've got a MSDN Livemeeting going on this afternoon (European time). Two demo's of each 15 minutes, so 30 minutes of talking.

Any tips from the professionals around here on preparation?

(I'd...

The data will duplicate. Just as you described in your question.

If you have one file with 10...

I would advice you to grab a good book on SSIS or find some tutorials online.

Look for the following keywords:

* dataflow

* flat file source

* ole db destination

Nice article Craig!

Really enjoyed reading it, despite it's lack of pretty pictures 🙂

@sherifffruitfly: check out the MCTS 70-448 and MCTS 70-433 certification exams

Great question, thanks.

Brandie Tarvin (5/6/2011)

---

Whoot! Did I mention I just got another story accepted? "The Hunt for Liberty Jones," my second science fiction story. And yesterday, I received the edits request.

Editor's Note:

---

...

avi_perez (5/6/2011)

---

Check out Pyramid Analytics. This stuff makes the other items on this page pale in comparison.

slick graphics and animations, incredible performance, highly scalable and powerful features unseen in the...

A pessimist...

dg227 (5/5/2011)

---

Try it (those MS links say exactly that: the design-time value will be re-loaded over a config file's value when using dtexec execution of a deployed package):

1. (in SSIS...

So it essentially boils down to this:

design-time configurations == design-time variable values?

I think not. I'm not 100% sure. I've used configurations in 2005 and 2008 a lot without any troubles,...

Hmmm, maybe I'm reading it wrong, but I believe MSDN says the following:

"The utility then reloads the configurations that were specified in the package at design time ..."

It reloads configurations,...

@dg227: I think there is a mix-up between syntax here.

You are talking about configurations specified at design-time, I'm talking about actual values specified for variables in the variables window at...