Data source appears to have been modified error

When trying to import an SP from SQL Server, I get a message stating that

"The data source appears to have been modified since it was last accessed. Refreshing may resolve this error."

The query I am trying to load is almost exactly the same as the one I loaded before it, only referencing a different table in SQL Server. The only other thing of note is that I have, for this particular table, to resolve an error about a collation conflict between SQL_Latin1_General_CP1_CI_AS and Latin1_General_CI_AS, which I have to run the below for all 3 columns in the table concerned.

Anyone have any ideas? I should add it's in Import mode, run as an advanced query which just calls the SP name and @ variable that goes with it.

ALTER TABLE YourTableName
  ALTER COLUMN OffendingColumn
    VARCHAR(100) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL

Need Help

Anonymous
6 years ago
In the end, I copied the relevant parts of the SP I needed to keep, then created a new one from an existing SP template, swapping out the main code. I called it something slightly different, and this time it worked a treat.

Maybe I created the SP already at some point either by accident, or not recalling, and this was why. Either way, renaming the SP and adding it again seems to clear this particular issue.

Forum Discussion

Data source appears to have been modified error

7 Replies

Related content

Report not appearing in app

Defining Event Grid as a source - Namespace doesn't appear

Modifier une source

Data source

Data flows are not appearing in the alphabetical data sources - past the letter P