This script rocks, thanks to the blogger

<a href="http://dotnetkeeda.blogspot.in/2009/09/bcp-command-to-export-data-to-excel.html"> BCP export to excel</a>

Can you post the SP which is created and giving error?

just put print statements after creation of every SP so that u can know which part is causing the problem..

or post your script..

Hi,

Glad to know that it helped you..

If you could post your script then i'll try to look into it..

Regards

Hi Diana..

Glad to know that it worked fine on your remote server..since you are running with windows authentication on your local server then try to remove the credentials from the...

Hi Diana,

I cheked your script on my local environment and it worked absolutely fine.

Now few things i have in my mind.

Check the userid and password for your DB in the...

Hi diana..

You can use the variable instead of the path in the query..and thats actually intended for dynamic path only..

For error..please debug and print the dynamic SQL getting prepared..and rectify...

Hi,

See updated script

for this and many other modifications..in this script..

Regards.

HI..

Just try to debug it and see where the problem is..

there may be a problem with compatible data type..and if it is then you can easily resolve it..

Regards..

Hi paul..

Thanks for the "timestamp" issue..would rectify it soon

Regards

Hi..

Thanks for bringing this in notice..actually this is a browser problem and i'd try to rectify it in next post..

Thanks

Hey ...

I've modified it for identity column and MAX data width..

enjoy.....

/*-- =======================================================================================

--Updated by : Samardeep Singh

-- for identity columns and MAX data width of a column

-- Author ...

Hi Deepthi,

Nice article, but needs to be update for e.g. varchar(max).

i.e. it doesnt work with column width "MAX"

regards

This may help you

http://blogs.conchango.com/jamiethomson/archive/2005/02/28/1085.aspx

just a small help for you...

http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:5773459616034

😛 is ": and P"