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.

Yes exactly. Once you have that, you're in business.

Even if you just use Row_Number() to generate one on the fly ... (if you're not too fussy about which rows end...

If you have two data sets

Set 1

1, 2

3, 4

Set 2

a, b

c, d

and you want to combine them to give something like

1, 2, a, b

3, 4, c, d

you need to...

Or ...

Instead of using the tables as your sources, use a query which includes the join. Then your data source is ready to go - this will be faster than...

Feed the two sources into a Merge Join transformation and from there map to your destination table (I'm assuming that the two source tables can be joined, of course).