Professional Web Applications Themes

Triggers and importing data once again - Microsoft SQL / MS SQL Server

According to my previous post, I am sure now, that the problem is in Import Data wizard (when not and when saving task as a DTS package). When I manually add recors everythong is ok. But importing data from access doesn't fire trigger for insert. May be it is something wrong with column mapping? But I do not chenge any setting in that wizad. Przemo...

  1. #1

    Default Triggers and importing data once again

    According to my previous post, I am sure now, that the
    problem is in Import Data wizard (when not and when saving
    task as a DTS package). When I manually add recors
    everythong is ok. But importing data from access doesn't fire
    trigger for insert. May be it is something wrong with column
    mapping? But I do not chenge any setting in that wizad.
    Przemo
    Przemo Guest

  2. #2

    Default Re: Triggers and importing data once again

    Hi

    The Data Transformation Task will call a Insert Bulk command. Unfortunately
    this is an Internal command which is not doented. The only solution I can
    think of would be to create a linked server and use a Execute SQL Task (if
    you still want to use DTS!) and use INSERT ... SELECT

    [url]http://msdn.microsoft.com/library/default.asp?url=/library/en-us/acdata/ac_8_md_03_8vhw.asp[/url]

    Maybe someone else in this group or microsoft.public.sqlserver.dts may have
    a better idea!

    John


    "Przemo" <p.dutkiewiczdeltatrans.pl> wrote in message
    news:036301c343d5$2524a740$a001280aphx.gbl...
    > Hi,
    >
    > Thanks. Your replay cleared me a lot of.
    > But I'd like to notice something more. BULK INSERT allows
    > only to copy from a text file and. My source is in Access
    > and Transform Data Task is used in DTS. So it is not
    > possible to write a BULK INSERT statement.
    > So have you got any idea ?
    >
    > Przemo

    John Bell Guest

  3. #3

    Default Re: Triggers and importing data once again

    If you are using the Microsoft OLE DB Provider for SQL Server for the
    DTS destination connection, triggers will fire if you uncheck 'Use fast
    load' under the Options tab of the Transform Data Task properties.
    Fully-logged inserts are needed for trigger processing.

    --
    Hope this helps.

    Dan Guzman
    SQL Server MVP

    -----------------------
    SQL FAQ links (courtesy Neil Pike):

    [url]http://www.ntfaq.com/Articles/Index.cfm?DepartmentID=800[/url]
    [url]http://www.sqlserverfaq.com[/url]
    [url]http://www.mssqlserver.com/faq[/url]
    -----------------------

    "Przemo" <p.dutkiewiczdeltatrans.pl> wrote in message
    news:036301c343d5$2524a740$a001280aphx.gbl...
    > Hi,
    >
    > Thanks. Your replay cleared me a lot of.
    > But I'd like to notice something more. BULK INSERT allows
    > only to copy from a text file and. My source is in Access
    > and Transform Data Task is used in DTS. So it is not
    > possible to write a BULK INSERT statement.
    > So have you got any idea ?
    >
    > Przemo

    Dan Guzman Guest

Similar Threads

  1. Importing data from one to another
    By DataPacks.com in forum Coldfusion Database Access
    Replies: 2
    Last Post: March 26th, 01:14 PM
  2. Importing FDF Data
    By Volker_Kleinschmidt@adobeforums.com in forum Adobe Acrobat Windows
    Replies: 5
    Last Post: May 7th, 03:08 PM
  3. Importing Excel data
    By chris in forum FileMaker
    Replies: 5
    Last Post: August 19th, 01:34 PM
  4. Triggers and importing data
    By Przemo in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: July 6th, 02:25 PM
  5. Importing lots of data
    By SriSamp in forum Microsoft SQL / MS SQL Server
    Replies: 4
    Last Post: June 30th, 02:29 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139