ssis和sql server中code page默认是中文

如果电脑系统是中文的
暂时只能更改单个database的默认语言成英文

use master

-- make sure no one else is using database
ALTER DATABASE test_db SET SINGLE_USER WITH ROLLBACK IMMEDIATE

-- change collation to Modern_Spanish_CI_AI_WS
ALTER DATABASE test_db COLLATE SQL_Latin1_General_CP1_CI_AS;

-- allow users back into the database
ALTER DATABASE test_db SET MULTI_USER

SELECT name, collation_name FROM sys.databases;  

可以查看每个database的默认语言