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

prennings (11/10/2013)

---

Hi all,

I was reading up on this article:

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/102924/

And I was wondering in the article it was about updating the tables of your database but not a complete new insert....

Depends on the code. But if you're using, for example, a data adaptor, that's using up RAM for sure.

:w00t:

Reminds me of a report one of my ex co-workers used to run every month.

It was a pay analysis and...