I would start by taking Excel out of the equation. Output the data to CSV (or fixed-width) and work from there.

SPtiruttani (11/14/2013)

---

Dear All,

I need the to subtract the value from the previous record and insert into another table

Declare @temp Table( [DeviceID] Int,[ctDate] DateTime,[Value] INT )

Insert Into @temp Values(1,'20131114 00:00:00',10)

Insert Into...

Does your SQL Agent proxy credential have access to the file? Is it a domain account?

Have a look here and see whether it helps.

The proxy account also needs to be associated with the SSIS subsystem, I think.

OK, maybe you could put some more sophisticated error-handling in the script in an effort to work out exactly which row is causing the error. I don't remember having any...

Are there any other errors? The one you posted doesn't really help that much, unfortunately.

Are you saying that all packages containing scripts fail when run under SQL Agent, or just...

It's not totally clear how you want to see the results. The following queries give you a count of NULLs in each column, for all rows in the table:

declare @Rows...

Details moved to other thread.

dan-572483 (11/13/2013)

---

What is the best approach for extracting data from a MySQL Database and importing it into MSSQL? 1) export to text file then import, 2) Set up...

The first thing I would do is try to work out at what stage the characters are being dropped. You can think of your package as going through the following...

Hi Dwain, I did consider this. But as the variable in question had a numeric datatype, I could not see how there could be...

If you run the packages in 32-bit mode, does that work?

How did you perform the migration of the packages? Have you tried redeploying them manually? (I'm sure you have.)

You are mixing string and integer data.

Try converting your integer variable to a string before you insert it into the code block.

You could try using the import wizard ...