Hi,

We had this same error in a SSIS package using a third-party ODBC driver - related to .Net Framework and variable length strings.

I had to setup redundant Error Redirections...

Found the cause of this - turning off User Account Control fixes it - also explains why we didn't get the issue under XP.

Hi,

Thanks for the info - strange it never happened for us with XP?

Cheers,

Matt

Another way to do an upsert is using the Slowly Changing Dimension data flow transformation. Just connect it to the data source and setup as a Type 1 SCD (updates...

Thanks for the workaround - assigning the db_dtsOperator permissions to the Guest a/c works Ok.

Something must have happened with the permissions for the sysadmin user, because it has dbo...