Koen,

I tried the expression RIGHT((DT_WSTR,18)"000000000000000000" + REPLACE(((DT_WSTR,18)[Copy of SHARES]),".",""),18)

Before I run the package my values are:

(Note that these values are coming from excel sheet)

Ex.

555555.666666

888888.000000

After execution:

000555555666666001

000000000000888888

I was hoping to...

Note: Assume the column is right justified

[Column1]

123456.00000

.12345

12345.12345

Evil Kraig,

Thanks for that expression. Really on the money with that. Taking that into consideration, how would I add zero's to the end of the string as well as...

Here is the image:

https://lh4.googleusercontent.com/-Po4aSse9G5w/TwNn2Mds0_I/AAAAAAAABJE/V042dxR4cB0/s1024/ParseFile.JPG

Unfortunately, I was incorrect with the information. Instead of this being a spreadsheet let's say this is a table in SQLServer, but the data looks...

Did you figure it out?

On the fast load option where on the destination side do I enable that feature? Is that under Properties / Custom Properties / Access Mode / OpenRowset using FastLoad

I am...

I did not choose the fast load option since I was not aware of that.

I am looking into that now.

Hello,

I am currently running BIDS from my desk and the spreadsheet is stored locally on my c drive as well.

The source seems to be fine since initially when executing...

Sorry about that didn't realize I was hijacking.

Already started the thread.

Thanks for the heads up.

Hello all,

I was reading the previous posts and have a similar issue. I am new to SSIS and SQL Server in general.

I created a basic package where my Control Form...

Hello all,

I was reading the previous posts and have a similar issue. I am new to SSIS and SQL Server in general.

I created a basic package where my...