March 10, 2014 at 7:18 am
[font="Comic Sans MS"]Hi
Iam working on sql server and performed some queries and got required tables as results.
Now I want to Export the table to a CSV file USING SCRIPT (only).
help me if anyone knows.
:w00t:[/font]
March 10, 2014 at 8:18 am
One option is the bcp command. This link http://technet.microsoft.com/en-us/library/ms162802.aspx gives more info.
-------------------------------Posting Data Etiquette - Jeff Moden [/url]Smart way to ask a question
There are naive questions, tedious questions, ill-phrased questions, questions put after inadequate self-criticism. But every question is a cry to understand (the world). There is no such thing as a dumb question. ― Carl Sagan
I would never join a club that would allow me as a member - Groucho Marx
March 11, 2014 at 4:15 am
sk.ruhulla (3/10/2014)
[font="Comic Sans MS"]HiIam working on sql server and performed some queries and got required tables as results.
Now I want to Export the table to a CSV file USING SCRIPT (only).
help me if anyone knows.
:w00t:[/font]
What kind of script?
As you're in the SSIS forum, I'm assuming that you want to use an SSIS package, is that correct?
March 11, 2014 at 11:10 am
sk.ruhulla (3/10/2014)
[font="Comic Sans MS"]HiIam working on sql server and performed some queries and got required tables as results.
Now I want to Export the table to a CSV file USING SCRIPT (only).
help me if anyone knows.
:w00t:[/font]
You can use BCP. But why do you want to do that way only ?
--
SQLBuddy
May 9, 2014 at 5:46 pm
You don't need a script task to export a table in SSIS , chose a dataflow task within SSIS. Make ole db the source and make a flat file your destination. Have you done this before?
----------------------------------------------------
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply