program or way i can automatically capture each new line of a sql table

i am looking for a way to get appended rows from a table as plain text files.
I have a microsoft sql database that renews every month "history1217" (historyMMYY) is the current database. on an irregular basis this database has a new line written to a table labeled "SignalHistory". it gets somewhere between 1-300 rows added every minuet as data trickles in. each new row of data has a [signalID] which is a unique number starting at 1MMYY, so the 1st row on this months database is 11217 and it simply counts up from there.
i would like to have a file folder that has files named 11217.csv (i don't really care what the file extension is, i would prefer columns be separated by | or tabs)
and these files would exist as soon as the row exists or at least very quickly after the row exists.
is there some utility i can use to do this, monitor the newest of these databases for changes and save these changes to a file?
LVL 1
csePixelatedAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
Have you tried using a trigger?
1
csePixelatedAuthor Commented:
I have not, im not very familiar with Microsoft Sql Querys.
https://docs.microsoft.com/en-us/sql/relational-databases/triggers/create-dml-triggers 
what would be the query I would have to enter for the trigger to accomplish this?
0
Pawan KumarDatabase ExpertCommented:
Provide some input and output in an excel...
Trigger will help but you need build logic inside that..
0
csePixelatedAuthor Commented:
I have since found an approximate solution to this after many failed attempts a powershell ps1 that is run frequently and outputs the last couple minutes worth of data as a file.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
csePixelatedAuthor Commented:
although I never actually got what i was looking for according to my original question. i found a solution that was more fitting to my situation.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SQL

From novice to tech pro — start learning today.