sql export syntax - repost

Closed

I have a query that I turned into a stored procedure in Microsoft SQL Server 2005 that is running to do calculations and I want the result set to be exported to a csv file. The stored procedure is being executed by a sql job. I can not use xp_cmdshell due to security violations. I would like to use bcp but it appears that it needs to use xp_cmdshell. I really don't want to use a batch file to do it. I would like to have two methods to accomplish this by a sql job. One method I would like to use CLR integration because this is enabled on the server. I don't care what the other method is but I just want to get the job done so I am open to suggestions. I only ask for two because I want to see what is easiest. I need to get this done within a few hours to a day because it is simple. I know this should be able to be accomplished with a few lines of code but just can't get what I had to work. This should be able to be performed by adding a few lines of code at bottom of procedure. Let me know your thoughts and time frame to work with me on it.

Skills: Database Administration, Microsoft, SQL

See more: export job, easiest job to get, sql server job, sql clr, syntax, sql integration, Microsoft SQL server, clr, export sql, microsoft sql server 2005, microsoft sql server csv, sql file csv, sql server export sql, sql syntax, export job sql, sql server clr, sql server integration, sql server query, quick export sql server, sql job, sql export csv remote server, sql job export, net sql server job, quickbooks export sql server, vb6 code export sql server data machine

Project ID: #5201654

12 freelancers are bidding on average $31 for this job

marasinghe82

Dear Sir, Boss I don't have 2005 environment right now . an you enable the TV session now . pls check following URL 100% it should work http://blog.sqlauthority.com/2008/02/06/sql-server-import-csv-file-into-sql- More

$25 USD in 3 days
(29 Reviews)
4.7
elboukharimu

Hi I'm very interested helping you resolving your query problem, I have more then 7 years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, ther More

$29 USD in 0 days
(17 Reviews)
4.7
wesolvevw

Even I prefer the CLR approach to be on safer side if you are just trying to do a csv file. If it is excel, it is not straight forward. If it just CLR proc to redirect the sproc output to csv file, I can do it in a day More

$34 USD in 3 days
(32 Reviews)
4.4
yubor

Hi. I am certified SQL Server expert (MCSE: DataPlatform). Would be glad to help you with this project. I think it should be realised using BCP or OPENROWSET. SQL-CLR can bring more troubles than you have at this momen More

$35 USD in 3 days
(22 Reviews)
4.2
hcy0212

Hi Spencey77, I have a solution for you, and need to confirm few things with you. Sincerely yours, John

$35 USD in 3 days
(6 Reviews)
4.1
truongnguyen86

Hi there, i can export using powershell in proc, pls share your details more. I'm ready to help you with this. Waiting for feedback bro.

$30 USD in 1 day
(7 Reviews)
3.2
AliSafder

HI spency, Its Ali Safder who did work for you earlier as well. I can get this work done as well. Lets finish this job.

$33 USD in 1 day
(3 Reviews)
1.9
theneshk27

I got good skills in SQL quires and data migrations. I am currently working as DB developer in a very large organization. Since I am a new freelancer I will do my best of ability to get a good feedback. Thanks in a More

$25 USD in 3 days
(1 Review)
0.0
jaimebennett

BCP does not require xp_cmdshell. It sounds like you've already done the hard part--getting the data to look how you want it. Exporting it using BCP will be easy. Thanks!

$25 USD in 0 days
(0 Reviews)
0.0
ipenacl

I am an experienced Software Developer with over 10 years experience in system migration and maintenance. regards

$35 USD in 4 days
(0 Reviews)
0.0
eflyingfish

Hi, I can do this with following methods in SQL 1. Using SQL subscription we can easily do this 2. SQL stored procedure to save result set into CSV 3 SSIS Thank you

$27 USD in 2 days
(0 Reviews)
0.0
GhaziOualha

Hi I can create a DTSX project in one hour and it will be executed by SQL JOB. Contact me and we will discuss further Wait for your response Thank you Ghazi Oualha

$30 USD in 0 days
(0 Reviews)
0.0
yoelfme

I'm a developer of applications and desktop programs in VB.NET, C #, I work with Oracle, SQL Server and MySQL, it might help

$28 USD in 1 day
(0 Reviews)
0.0