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

If your input data is in a string, you cannot use date functions on it.

Use substring to extract the parts of the string you are interested in and do...

ronan.healy (9/29/2014)

---

i have a date coming in like this

21/03/2018

I keep getting an error. do I have to convert it I tried the following code to try and convert it but...

antonela (9/26/2014)

---

My stored procedure is not so simple.I have a lot of values for that parameter and I have to do different things for every case.I can not use the...