Ok thanks. I'll see if I am able to remove their sysadmin.

They really only need access to read write data, execute sps, functons. Thats their only legitimate role on the db anyway.

You can use with encrytion on  view etc...

Thanks Gail.

Ok  , I'll look into revoking the sysadmin rights. I'm not sure that will be possible.

Whats the best way of securing all design from...

I can get this to work with an ODBC connection. Is it possible to use an ODBC connection DSN less. I cant get my data to load to my table...

Thanks Phil - it could be to do with datatype or size even?

Or
[Execute SQL Task] Error: Executing the query "EXEC ProcTPSUpdate ? , ?" failed with the following error: "The statement has been terminated.". Possible failure reasons: Problems with the...