How to export SQL table to *.CSV file automatically for every sec

Question

1.00/5 (1 vote)

See more:

Hi Guys,

I'd like to export Table from SQL database to *.CSV file (mapped Table to CSV) periodically at the end of each shift automatically. I heard that it can be done using SSIS.

Also I have a condition while mapping source to destination based on two columns value in the table

one of the columns, header4, value =1 or 2 or 3 where only the rows whose value is 1 need to be uploaded to csv, value 2 0r 3 no need to upload.

another column header5, value= 1 or 2 where 1= Existed column name so search the same name in csv and append the rows , 2= Add one more new column to csvfile and upload data for appending

Finally i want this to be a executable file... because to send customer
I am new to SSIS and SSMS as well, pl help me

How to attach the excel here,which i made sample

Thanks

Posted 6-Nov-13 12:52pm

Member 10384956

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

_Damian S_ · Answer 1 · 2013-11-06T14:48:00

Create a view that returns the data you are looking for. eg:

SQL

select FIELDLIST from TABLENAME where header4 = 1

Then use the view in a data transformation package (I know they are called something else these days, but it's the same thing) that exports the results to CSV. Use the Task Scheduler to schedule this to happen as needed.