Exactly what I had in mind.

ronan.healy (10/20/2014)

---

No there is no great way to do this. The question I was wondering with the padding was more that will work well. But I was wondering when it...

Eirikur, do you ever do anything slowly? 😛

Steve Jones - SSC Editor (10/20/2014)

---

There isn't a great way to do this. You'd probably need to think about importing as ints, then transforming with the appropriate number of 0s...

Wow, good question.

If you were to model this in the database as you suggest, I would think that the best-performing solution would be one which generated dynamic SQL to perform...

What's the datatype of the column in the target table?

John's solution handles everything up to 999, not just 100.

We don't know your tables, your data, your business...

OK, I think I worked it out. Do you mean something like this? By the way, please include sample DDL next time.

if object_id('tempdb..#Order', 'U') is not null

...

winston Smith (10/20/2014)

---

I have data in the following format

OrderID ItemName UnitPrice Quanity

1 ...

Then where were you hoping...

Do you have a table somewhere which includes both the code and the description?

May I ask why you are using a cursor for this?

I'm not sure how a script task would help you here.

I think you may mean a script...

coreyjbaum (10/14/2014)

---

I have a package that creates and excel file and dumps some data in, and then renames the worksheet to the current date using a script task at the...

Sure. Have a look here.