OK, so I have two SQL tables in my solution, and overnight the password for the SQL access account expired. I have changed the account to non-expiring and reset the password, but when running the two update scripts, one works perfectly, the other runs instantly yet completes. Stepping through the script, It goes to the SQL layout, and that is empty, so it can't put data from the SQL table into the holding table. Of the two tables (these are in-fact Views) which contain the data (both are correct and contain data on the SQL server), only one of the two is populated.

The only change I am aware of is switching the source database table to unicode - could this be the issue?

Thanks

Martin

The unicode question is not relevant - the other view that I can see also has fields in unicode and these work perfectly. I did also adapt my view to cast the columns back to varchar, but that made no difference.

 

How come I can see one view from the same database, but not the other?

 

Thanks

 

Martin

I've found the issue here - it was a database permissions issue which has now been resolved.