If I told you that my car was "not working", would you be able to tell me how to fix it?

Use the Advanced Editor for your source data and check/change the datatypes of the fields there.

Does this happen in all circumstances (ie, new and existing packages, new and existing script tasks ...)?

Your source data is already varchar (maybe Varchar(8) would be better), so why not use DSTR and avoid any need for data conversions?

The Data Viewer results you mention are consistent...

Yuk, I don't like the sound of that. If you are bringing all of the details into a temp table first and then processing from there out to master/child tables,...

Don't know, but why don't you just give it a try and see what happens? It's not difficult to set up a test.

Or, if you can be bothered setting things up so that you have access to the Excel object model via script (a bit of a pain), you can get the...

roundel1900 (8/11/2009)

I don't...

Do I have to do everything? I said it was untested and expected that you could work it out ...

Turns out there is no LEFT function available, so you'll have...

Ah - you said you were having a problem stripping off leading zeros and that confused me, but now I understand.

So you need something like (completely untested)

LEFT('00000', 5 - LEN(Zip))...

OK, I think an easy way to do this is to put in a data conversion transformation and convert from your current string field to an integer - this will...

If you really appreciate problems, I have some really juicy ones for you :laugh:

Can you provide sample data - source and required output - please? I'm English & not really...

Can you throw away the old record, if a newer one exists, and just use the newer one for everything?

OK, just tried this with my own system:

"select f1, f2 from account where accountid = '" + @[User::AccountID] + "'"

is the value of SqlStatementSource, under Expressions.

Did you try using the 'Expressions' property as I suggested? Otherwise your statement will not get evaluated ...

You will be able to paste your variable into your SQL statement using...