Hi, I am using SSIS to move load data from SQL Server 2014 developer edition to windows azure sql database (ado.net connection). I am doing this for a couple of tables and they all work fine but one gives "cannot access destination table" error in SSIS. I can get to this table and have read/write access. This table has a clustered index, for the matter of fact all the tables I am trying to load data to have clustered index but only 1 table is failing not sure why? The error does not give more insight either.
Could you please guide me....
Thanks in advance.........