dbTalk Databases Forums  

cannot import data manually on sql server 2005 because of collatio

Go Back dbTalk Databases Forums Databases microsoft.public.sqlserver.dts cannot import data manually on sql server 2005 because of collatio

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss cannot import data manually on sql server 2005 because of collatio in the microsoft.public.sqlserver.dts forum.



Reply
Page 1 of 2 1 2 >
 
Thread Tools Display Modes
  #1  
Old   
c676228
 
Posts: n/a

Default cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 05:31 PM





Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #2  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM





Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #3  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #4  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #5  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #6  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #7  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #8  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #9  
Old   
c676228
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-30-2008 , 11:56 PM


Hi all,

I finally make it work, but I still need you help to explain something for
me. I completely feel that ssis is a different animal from dts

instead of using destination of import to be microsoft OLE DB provider for
sql server and to a table I created before importing ,

I chose sql native client as destination, make sql server 2005 create a
table automatically. if finally imported data to the destiantion table.(and
use locale English (United States))
But when I take a look at the table script, it totally different, wonder how
should I deal with it. It seems that the auto created table cannot hold data
I want.
here is table I created and wanted data to be imported in this table but
unsuccessful:

CREATE TABLE [dbo].[WorldMed_DataEase](
[AgentCode] [char](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[InsuredBirthday] [datetime] NOT NULL,
[Street] [char](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [char](50) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDate] [datetime] NULL,
[PassportNumber] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [varchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [char](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NOT NULL,
[PlanChosen] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[EffectiveDate] [datetime] NOT NULL,
[SpouseSurname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [char](20) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [datetime] NULL,
[Child3ArrivalDate] [datetime] NULL,
[Child3EffDate] [datetime] NULL,
[Child3ExpDate] [datetime] NULL,
[total] [int] NOT NULL,
[AMDoption] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [varchar](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [char](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL,
[NotRenewable] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [char](5) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Deductible] DEFAULT (''),
[Rider2Select] [char](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NOT NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_Rider2Select] DEFAULT (''),
[TripDestination] [varchar](100) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
CONSTRAINT [DF_TIS_WorldMed_DataEase_TripDestination] DEFAULT (''),
[Country] [char](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [char](25) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL
) ON [PRIMARY]

The following is the table auto created by sql server 2005 during import,
import data successfully, but it seems that table is completely different
from what I created, why?
CREATE TABLE [dbo].[WorldMedExport](
[AgentCode] [bigint] NULL,
[InsuredSurname] [nvarchar](12) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredBirthDay] [datetime] NULL,
[Street] [nvarchar](40) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[City] [nvarchar](18) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[State] [nvarchar](13) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Zip] [nvarchar](6) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[email] [nvarchar](30) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[DayPhone] [nvarchar](14) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EveningPhone] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[InsuredArrivalDateInsured] [datetime] NULL,
[PassportNumber] [nvarchar](9) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[PassportCountry] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[School] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Visa] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CurrentExpDate] [datetime] NULL,
[PlanChosen] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[EffectiveDate] [datetime] NULL,
[SpouseSurname] [nvarchar](8) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseFirstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[SpouseBirthday] [datetime] NULL,
[SpouseArrivalDate] [datetime] NULL,
[SpouseEffDate] [datetime] NULL,
[SpouseExpDate] [datetime] NULL,
[Child1Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Firstname] [nvarchar](10) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child1Birthday] [datetime] NULL,
[Child1ArrivalDate] [datetime] NULL,
[Child1EffDate] [datetime] NULL,
[Child1ExpDate] [datetime] NULL,
[Child2Surname] [nvarchar](7) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Firstname] [nvarchar](11) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child2Birthday] [datetime] NULL,
[Child2ArrivalDate] [datetime] NULL,
[Child2EffDate] [datetime] NULL,
[Child2ExpDate] [datetime] NULL,
[Child3Surname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Firstname] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3Birthday] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ArrivalDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3EffDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Child3ExpDate] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Total] [real] NULL,
[AMDOption] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[inoroutbound] [nvarchar](15) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[CertificateNumber] [smallint] NULL,
[NonRenewable] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Reissue] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Deductible] [smallint] NULL,
[Rider2Select] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[TripDestination] [nvarchar](26) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[Province] [nvarchar](1) COLLATE Chinese_Taiwan_Stroke_CI_AS NULL,
[HomeCountry ] [nvarchar](2) COLLATE Chinese_Taiwan_Stroke_CI_AS
NULL
) ON [PRIMARY]

does that mean I have to manually adjusted to data length what I want?
--
Betty


"c676228" wrote:

Quote:
Hi all,

Our origianl sql server 2000 database was created with COLLATE
Chinese_Taiwan_Stroke_CI_AS by someone, though we never store any Chinese
charater in database. In sql 2000 I never encounter any problem when we
import data from any flat files to any tables with this collation.

Now after I upgrade this database from 2000 to 2005, I encounted a problem
when
I tried to import a flat data file(the data format and similar data to sql
2000) to sql server 2005 data table with this COLLATE
Chinese_Taiwan_Stroke_CI_AS.

The error message is as follow:
Validating (Error)
Messages
• Error 0xc00470b6: Data Flow Task: The LocaleID 1028 is not installed on
this system.
(SQL Server Import and Export Wizard)

• Error 0xc004706b: Data Flow Task: "component "Source - WorldMedExport_txt"
(1)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)

• Error 0xc004700c: Data Flow Task: One or more component failed validation.
(SQL Server Import and Export Wizard)

Error 0xc0024107: Data Flow Task: There were errors during task validation.
(SQL Server Import and Export Wizard)

It seems that I have install localeID 1028, can you tell how to get this
Locale for sql 2005.

Thank you.

Betty

Reply With Quote
  #10  
Old   
Charles Wang[MSFT]
 
Posts: n/a

Default RE: cannot import data manually on sql server 2005 because of collatio - 03-31-2008 , 12:11 AM


Hi Betty,
I understand that you could not upgrade your SQL Server 2000 database to
SQL Server 2005 due to the error "The LocaleID 1028 is not installed on
this system.".
If I have misunderstood, please let me know.

I think that the problem is that there is no language support for
Chinese_Taiwan on your server on which your SQL Server 2005 is running.
Your original collation of your SQL Server 2000 database is a Windows
collation, and this requires that the related language and locale must be
installed on your system. I recommend that you first install the language
collection via the following steps:
From Start menu, select Settings then Control Panel, start Regional
Options, click on Languages tab, in Supplemental language support box,
check the checkbox of the language collection "Install files for East
Asian languages" and then click OK. After this, additional files will be
copied to your machine. You may need to provide the Windows system CD or
the network share name. After reboot, support for new languages will become
available.

Regarding language collection and locale, you may refer to this article:
Windows XP/Server 2003 - List of Locale IDs, Input Locale, and Language
Collection
http://www.microsoft.com/globaldev/r...p/xp-lcid.mspx

Additionally if you have no need to use the collation
Chinese_Taiwan_Stroke_CI_AS for your database, I recommend that you change
the database collation to a common collation, such as Latin1_General. You
may also want the following references:
Setting and Changing the Database Collation
http://msdn2.microsoft.com/en-us/library/ms175835.aspx
Windows Collation Name
http://msdn2.microsoft.com/en-us/lib...7(SQL.80).aspx
How to transfer a database from one collation to another collation in SQL
Server
http://support.microsoft.com/kb/325335

Hope this helps. If you have any other questions or concerns, please feel
free to let me know.


Best regards,
Charles Wang
Microsoft Online Community Support
================================================== =========
Delighting our customers is our #1 priority. We welcome your
comments and suggestions about how we can improve the
support we provide to you. Please feel free to let my manager
know what you think of the level of service provided. You can
send feedback directly to my manager at: msdnmg (AT) microsoft (DOT) com.
================================================== =========
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for
non-urgent issues where an initial response from the community
or a Microsoft Support Engineer within 1 business day is acceptable.
Please note that each follow up response may take approximately
2 business days as the support professional working with you may
need further investigation to reach the most efficient resolution.
The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by
contacting Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscripti...t/default.aspx.
================================================== ==========
This posting is provided "AS IS" with no warranties, and confers no rights.
================================================== =======





Reply With Quote
Reply
Page 1 of 2 1 2 >

« Previous Thread | Next Thread »



Thread Tools
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.


Contact Us - dbTalk Databases Forums - Archive - Top