Padam Tripathi Posted December 8, 2020 Share Posted December 8, 2020 Spotfire 7.x => Data type of column has changed in the SQL Server then i got a message called data type changes in source data then i deleted the table. After that i am trying to load the table after refreshing the schema but it throws an varchar to int covnersion errror. we did not use the information link for the connection. Link to comment Share on other sites More sharing options...
Paul Shumaker Posted December 9, 2020 Share Posted December 9, 2020 Can you query the table directly Are there any calculated columns that relied on the old column datatype How are you connecting to the source Link to comment Share on other sites More sharing options...
Padam Tripathi Posted December 10, 2020 Author Share Posted December 10, 2020 Yes, i can query the table and there is no calculated columns. Yes i can connect the source. When Spotfire suggest that datatype changed it means that it is trying to get the latest schema from the database. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now