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

Hi Steve

It's easy - take a look here.

I am happy to have been of help - although, with hindsight, I feel that we should have got to this sooner 🙂

Phil

Sounds like you're well on the way to creating a script component to do the job.

I will write down my thoughts, just in case they include anything you haven't considered.

The...

Craig Farrell (12/2/2010)

---

LutzM (12/2/2010)

---

In that case, either an IIF statement or REGEX should help. (Google regex or IIF in ssis for details.)

You'd basically use a script component after your data...