i put

INSERT INTO BC

SELECT '001','teste', RIGHT( '000' + CAST( n AS varchar(4)), 4)

FROM dbo.Tally

WHERE n <= 9999

and returns this error msg

Erro: Connectivity error: [Microsoft][ODBC SQL Server Driver][SQL Server]Invalid object name 'BC'.

table bc exists