Results 1 to 19 of 19

Thread: SQL 2008

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Registered 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

  2. #2
    Registered 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

  3. #3
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028
    Quote Originally Posted by orpheus View Post
    , "ID" auto increment . Column mappings, "Enable identity insert".
    , ?
    , , ID-...

    , ID 4byte integer.
    ASRock B550M Pro 4; Ryzen R5 3600; 2x16 GiB G.SKILL Aegis 3200; 1TB Samsung QVO 960 + 3TB Seagate IronWolf; Zalman Z1

  4. #4
    Registered User
    Join Date: Feb:2014
    Location: Shumen
    Posts: 7
    Quote Originally Posted by hateras View Post
    , ?
    , , ID-...

    , ID 4byte integer.


    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 - .

  5. #5
    Registered User hateras's Avatar
    Join Date: Jan:2011
    Location: Kronos III
    Posts: 1,028

    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

  6. #6
    Registered User
    Join Date: Feb:2006
    Location: Plovdiv
    Posts: 392
    Quote Originally Posted by hateras View Post

    select max(ID) from [dbo].[N_GroupSP]
    ?

    : ID foreign key , , .
    .. , .
    ID / . "". .

  7. #7
    Registered User
    Join Date: Feb:2006
    Location: Plovdiv
    Posts: 392
    : . . . , , ..

    " ".

  8. #8
    Registered User
    Join Date: Feb:2014
    Location: Shumen
    Posts: 7
    .... "" .. , , ...

  9. #9
    XaMaB's Avatar
    Join Date: Nov:2001
    Location:
    Posts: 20,387
    , ?
    " " , ?
    : XaMaB; . 0.42

    In God we Trust (all others must submit a X.509 certificate). , ()

  10. #10
    Registered User
    Join Date: Feb:2014
    Location: Shumen
    Posts: 7
    .. , SQL , ,

  11. #11
    hgeorgiev's Avatar
    Join Date: Mar:2009
    Location: Burgas
    Posts: 51
    Column type: string
    Column type: int?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Copyright © 1999-2011 . .
iskamPC.com | mobility.BG | Bloody's Techblog | | 3D Vision Blog |