Well, I'm glad it worked. But the mixture of char data types and arithmetical operations makes me find it difficult to believe that that was what you wanted!

I think I misplaced a bracket. How about this?

update tablename

set lineno = cast((cast(lineno as int) - 12) as char(4)), sysmodified=getdate()

where 1=1

and entry=545554

and type='X'

and cast(lineno as int) >=568

So there's your problem. It's non-numeric. You need something more like this (untested):

update tablename

set...

What's the datatype of LineNo?

If it's on a local drive on the server, I would not expect it to be...

Vic Rauch-303403 (10/2/2014)

---

I agree with that 100% Problem is...

No problem and good luck. 'Remote' troubleshooting is never fun. You need to get yourself a good contact in IT who has the power to work through this with you!

Vic Rauch-303403 (10/1/2014)

---

Everything is hard coded, and as simple as possible. I have 5 steps. Empty the SQL table (OperationalData), import from Excel (three step process, The source...

Are you using two separate data flows to do the imports? (Rather than a fancy Foreach container.)

How are you setting the run-time values of things like file name and file...

Is the spreadsheet located on a local drive on the server?

If not, can you try putting the spreadsheet there and seeing whether it works? If it does, this is likely...

From the initial post:

I have a Nullable columns. I want the value to be zero...

Most people on this forum speak English. If you can translate your question, you will probably get a better response.

Unless you are correcting data as it moves from Excel to Access, I cannot think of any reason why you could not use SSIS to import the data from Excel....

antonela (9/29/2014)

---

I wanted to avoid 'insert into #table select * from table'... and only use 'select * into #table from table' simply because is too fast...

But I think that...

They...