Results 1 to 19 of 19
Thread: SQL 2008
Hybrid View
-
12th February 2014 13:50 #1Registered User
Join Date: Feb:2014
Location: Shumen
Posts: 7
SQL 2008
,
- ...
ERP SQL server 2008. Import . .... ... , Review Data Type Mapping . :
[Source Information]
Table: C:\Documents and Settings\Admin\Desktop\N_GroupSP.txt
Column: Column 0
Column Type: string [DT_STR]
SSIS Type: string [DT_STR]
Mapping file (to SSIS type):
[Destination Information]
Destination Location : MARIA\SQLEXPRESS
Destination Provider : SQLNCLI10
Table: [dbo].[N_GroupSP]
Column: ID
Column Type: int
SSIS Type: four-byte signed integer [DT_I4]
Mapping file (to SSIS type): C:\Program Files\Microsoft SQL Server\100\DTS\MappingFiles\MSSQLToSSIS1 0.XML
[Conversion Steps]
Step 1: DT_STR to DT_I4
SSIS conversion file: C:\Program Files\Microsoft SQL Server\100\DTS\binn\DtwTypeConversion.xm l
:
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Success)
- Setting Destination Connection (Success)
- Validating (Error)
Messages
Error 0xc0202049: Data Flow Task 1: Failure inserting into the read-only column "ID".
(SQL Server Import and Export Wizard)
Error 0xc0202045: Data Flow Task 1: Column metadata validation failed.
(SQL Server Import and Export Wizard)
Error 0xc004706b: Data Flow Task 1: "component "Destination - N_GroupSP" (18)" failed validation and returned validation status "VS_ISBROKEN".
(SQL Server Import and Export Wizard)
Error 0xc004700c: Data Flow Task 1: One or more component failed validation.
(SQL Server Import and Export Wizard)
Error 0xc0024107: Data Flow Task 1: There were errors during task validation.
(SQL Server Import and Export Wizard)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Success)
- Copying to [dbo].[N_GroupSP] (Stopped)
- Post-execute (Stopped)
? .... . , , Studio . .
, . . .
, skype: marcheva_m
-
12th February 2014 15:07 #2Registered User
Join Date: Nov:2007
Location:
Posts: 52
, "ID" auto increment . Column mappings, "Enable identity insert".
asus p5q-e, q9400@3,4 + scythe mugen 2, 2x2gb g.skill 8000clp5d, sapphire radeon 6950 1gb, audigy2 zs, 2xhitachi 160gb raid0 + hitachi 640gb, chieftec 550w, chieftec aegis, dell s2309w, logitech wave pro, logitech x-540
-
14th February 2014 00:52 #3
-
14th February 2014 10:08 #4Registered User
Join Date: Feb:2014
Location: Shumen
Posts: 7
-
14th February 2014 12:37 #5
select max(ID) from [dbo].[N_GroupSP]
?
: ID foreign key , , .
.. , .ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
14th February 2014 13:57 #6Registered User
Join Date: Feb:2006
Location: Plovdiv
Posts: 392
-
12th February 2014 15:14 #7Registered User
Join Date: Feb:2006
Location: Plovdiv
Posts: 392
: . . . , , ..
" ".
-
12th February 2014 15:48 #8Registered User
Join Date: Feb:2014
Location: Shumen
Posts: 7
.... "" .. , , ...
-
12th February 2014 15:57 #9
, ?
" " , ?: XaMaB; . 0.42
In God we Trust (all others must submit a X.509 certificate). , ()
-
12th February 2014 16:02 #10Registered User
Join Date: Feb:2014
Location: Shumen
Posts: 7
.. , SQL , ,
-
12th February 2014 16:14 #11




Reply With Quote

Lenovo ThinkPad 15 IdeaPad 15
5th May 2023, 22:16 in