Some background information would help: why are you doing this? Please give an example of the layout you want to create. What are the inputs/variables?

da-zero (12/16/2010)

---

Oh allright, it is for an interview. Why didn't you mention this in the beginning?

Your answer should definately be:

first yellow boxes. If you're lucky, green boxes. If not, red...

Please be more specific. At the moment, my answer would be

1) Job starts

2) Job executes

3) Job completes

which I doubt is the answer you require.

This might help you.

Your description is a little terse, but I get the gist. No matter how many times you have to map the columns of the table you are...

Dan Guzman - Not the MVP (12/10/2010)

---

Phil Parkin (12/10/2010)

---

Is there any reason why you cannot engineer the entire process, from picking up a row of data from your source, to...

I agree with Craig: that post was much clearer.

I think perhaps you are thinking of SSIS in the wrong terms: SSIS gives you access to pipelines of data, rather than...

I've read through this thread three or four times and I still do not understand what you are trying to do.

A data flow takes data from one place, processes it...

And what is your question?

Your initial post referred to 'blank' data.

Now you are asking why the text value '199-B' won't post to an integer field. I can't understand why you would ever expect that...

It's a valid question, but here's mine in response:

If you want to get somewhere fast, would you try to fix your injured camel when you've been offered a racehorse as...

You should really test it - wouldn't take long. Don't use your project to test - set up something manageable and quick.

But if by 'blank' you mean an empty string,...

So satisfying when you solve your own problems & no one else has a clue 🙂

melissa.jones (12/3/2010)

---

Mukti (6/18/2009)

---

If you are using migration wizard it must have converted it into ssis. If you connected to Integration Services then under Stored Pacakges you will find your migrated...

Whenever I do date stuff like that, I tend to put it into universal format first (YYYY-MM-DD HH:MM:SS) and then just map it directly to the destination column - no...

Try using double quotes " instead of single in your expression.