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

Nevyn (11/6/2013)

---

Thanks for the suggestion, but it appears to still not work.

This feature would work for testing different environments in SSDT (for example, a different server name to connect to...

Nevyn (11/6/2013)

---

Hi Phil,

I am using environments for when the project is published to the server (or will be, that is part of what I was setting up). ...

As you're on SSIS 2012, you should consider creating an 'environment' which contains your connection strings and use the 'Configure' option to map those connection strings to connection managers in...