kevinsql7 (10/3/2014)

---

Thanks Phil. Could you share how to set the security on SQL Server so that the developers do not have the rights to deploy to the sql servers? I...

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