Mark Forums Read

After Insert trigger copy rows to a file

Go Back

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

Reply

Page 1 of 7

1

#1

Old

Mark

Posts: n/a

After Insert trigger copy rows to a file - 07-17-2008 , 03:04 AM

I would like all records inserted into a database table to be copied into a
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Reply With Quote

#2

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#3

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#4

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#5

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#6

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#7

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#8

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#9

Old

jhofmeyr@googlemail.com

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 03:52 AM

On Jul 17, 9:04*am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:

Quote:

I would like all records inserted into a database table to be copied intoa
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

#10

Old

Mark

Posts: n/a

Re: After Insert trigger copy rows to a file - 07-17-2008 , 04:13 AM

Thanks for the reply. It's SQL server 2000. We would probably want the
records exported every 5 minutes or so, although this is not critical.

Mark

"jhofmeyr (AT) googlemail (DOT) com" wrote:

Quote:

On Jul 17, 9:04 am, Mark <M... (AT) discussions (DOT) microsoft.com> wrote:
I would like all records inserted into a database table to be copied into a
text file. (A 3rd party application will move this file and import the
records into another database).

I've seen how to create a trigger to copy inserted records into another
table, but I have no idea how to do copy the data to a file. Any help will be
much appreciated.

Hi Mark,

Do you need the file to be created in realtime? Or just exported once
an minute / hour / day / etc? Also, what version of SQL Server are
you using?

Good luck!
J

Reply With Quote

Reply

Page 1 of 7

1

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded 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.