Wednesday, September 26, 2012

SSMA error message S2SS0015

Unparsed SQL, cannot converted

 Please Check the Script to satisfy the following best practices to avoid the S2SS0015 error message.
1.Required space should be there,in between column and sql server keywords.
2.Check wether,given keywords available in sql server.
3.Need to check,variable declaration is correct.
4.Check for syntax error.

INSERTINTO #temp_swtch
 (           column1,
             column2,
             column3)
       VALUES (
            'first value',
            'second value',
            1 )

In the above given statement,Space character missing between INSERT and INTO.
If we change the statement like below we can resolve the S2SS0015 Error.

INSERT INTO #temp_swtch
 (           column1,
             column2,
             column3)
       VALUES (
            'first value',
            'second value',
            1 )

Please click here to know about sybase to sql server migration issues

No comments:

Post a Comment