Recenently,I finish my fisrt task in new company, I have tested many times in local computer, and it run smooth. But when i deploy a version to UAT. many problems were occured.
Case 1:
My department colleage can access the db. but other department can't.
reason: because in web.config 'Integrated Security' was seted to 'true', it should be setted to false.If the value is true,use should access db by his account. due to our department is IT,So we can access db. but other department can't access.
Case 2:
Transmittal is not base on standard.
SSIS,Table should create by bat command.
Case 3:
Meet unicode problem.
Because I created db filed with 'varchar' before.Due to this filed can store chinese tranditional information, so it occur problem.
varchar is used to store english and numeric,it don't support un-unicode, so we should use 'Nvarchar' to store other language data.
Case 4:
gibberish code problem.
Because the PC which store SSIS didn't support chinese. So If the original data source contained chinese word. The related
destination data should become to gibberish code. So we should change the PC's setting to support Chinese language.