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 #3ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1
-
14th February 2014 10:08 #4Registered User
Join Date: Feb:2014
Location: Shumen
Posts: 7
ID Name
1 Áþäæåò
4 ÈÁÑÔ
5 Äðóãè äåéíîñòè
6 Äîã...............
7 Ðåãèîíàëíî ðàçâèòèå
9 Ðàçïëàùàòåëíà àãåíöèÿ
10 Êîõåçèîííè ôîíäîâå
14 Îêîëíà ñðåäà
22 ×îâåøêè ðåñóðñè
24 ÄÔÇåìåäåëèå
31 ÔÕÍ - ñîáñòâåíè
33 BG051PO001-4.3.04-0020
34 BG051PO001-3.3.06-0003
35 BG051PO001-3.3.07-0002
37 BG051PO001-4.2.06
38 BG051PO001-3.1.07-0040
Åòî òîâà å òàáëèöàòà êîÿòî òðÿáâà äà ñå èìïîðòíå.....è äà îïèòàõ ñ îòìåòêàòà íà òîé åòàï ...è íå ñå ïîëó÷èõà íåùàòà, äðóãîòî êîåòî îïèòàõ å èãíîðèðàõ ID êîëîíàòà è íåùàòà ñòàíàõà, íî òîâà ID â ñëó÷åÿ ìè å îò çíà÷åíèå è íåæåëàÿ SQL äà ãî ñúçäàâà êàòî ïîðåäíà íîìåðàöèÿ ,à òîé òî÷íî òîâà ïðàâè ïðè èìïîðòà ñëåä êàòî èãíîðèðàì êîëîíàòà ID. Äð ìè ïðîáëåì å ...âñå ïàê óñïÿõà äà ñå èìïîðòíàò äàííèòå ,íî â ñúîâåòíèÿ ñîôòóåð òåçè äàííè íå ñå âèæäàò. Çíàì íÿêúäå íåùàòà òî÷íî ñ òàçè òàáëèöà ñà íàâúðçàíè ,ðîâÿ ñå îò âå÷å áëèçî äâå ñåäìèöè è òàêà è íå îòêðèõ êúäå å âðúçêàòà ì/ó òî÷íî òàçè òàáëèöà åâåíòóàëíî ñ íÿêîÿ äðóãà ....
Ñëåäâàùèÿ ìè ïïðîáëåì å íîìåíêëàòóðàòà êîÿòî äîðè è ID äà áëîêèðàì òàì èíôîðìàöèÿòà è êîëîíèòå ñà äîñòà è äàâà ãðåøêà â òåêñòîâèòå êîëîíè . Àêî íÿêîé èìà æåëàíèå äà ïîìîãíå áèõ ìó äàëà SQL áàçàòà è åäèí ôàéë êîéòî òðÿáâà äà ñå èìïîðòíå äà îïèòà íÿêîé ïî îïèòåí äà âèäè êúäå òî÷íî äîïóñêàì òàçè ãðåøêà .
Áëàãîäàðÿ âè âñå ïàê çà îòãîâîðèòå äî òóê è òîâà ñ ID -òî íàèñòèíà ñðàáîòè íî ìè å îò çíà÷åíèå â ñëó÷åÿ .
-
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 Ìîáèëíè êîìïþòðè