August 22, 2016 at 6:16 am
hey .
i want to create job that make table export to csv.
i know how do to this in gui only
thanks
August 22, 2016 at 6:36 am
Eirikur Eiriksson (8/22/2016)
Can you elaborate a little bit further on this, i.e. source details, destination details, limitations etc.?Are you familiar with bcp?
😎
i have local instance .
i want to take export of one talbe from db to csv file . and after this to send mail whit this csv
August 22, 2016 at 6:47 am
Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let us know the full details for the best advice.
😎
August 22, 2016 at 6:54 am
Eirikur Eiriksson (8/22/2016)
Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let us know the full details for the best advice.😎
i want sched job
August 22, 2016 at 7:01 am
Easiest way is to use SSMS -> Export Data and Save as SSIS package, then schedule the execution of the package.
😎
August 22, 2016 at 7:04 am
Eirikur Eiriksson (8/22/2016)
Is this a one-off or do you want to do this regularly, i.e. as a scheduled job? There are quite few options, bcp, sqlcmd, SSIS etc., please let us know the full details for the best advice.😎
i get this error
when i run
August 22, 2016 at 8:00 am
RESOLVED -
I do this
sqlcmd -S myServer -d myDB -E -o "MyData.txt" ^
-Q "select bar from foo" ^
-W -w 999 -s","
August 22, 2016 at 8:08 am
liorvikel (8/22/2016)
RESOLVED -I do this
sqlcmd -S myServer -d myDB -E -o "MyData.txt" ^
-Q "select bar from foo" ^
-W -w 999 -s","
Good stuff and well done!
😎
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply