Mombu the Microsoft Forum sponsored links

Go Back   Mombu the Microsoft Forum > Microsoft > Newbie Help
User Name
Password
REGISTER NOW! Mark Forums Read

sponsored links


Reply
 
1 17th July 04:17
austin henderson
External User
 
Posts: 1
Default Newbie Help


Looking to create a flat file from a stored proc that is comma delim.. can
this be done? I know I can use DTS but the table is a temp table and that
wont work.

Thanks for your help in advance.

--
Austin Henderson <><
Network Administrator
  Reply With Quote


  sponsored links


2 17th July 04:18
jasper smith
External User
 
Posts: 1
Default Newbie Help


You can shell out to bcp via xp_cmdshell but will have to use a global temp
table (##) as bcp will create it's own connection and your local temp table
would not be visible to it.

--
HTH

Jasper Smith (SQL Server MVP)

I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org

Looking to create a flat file from a stored proc that is comma delim.. can
this be done? I know I can use DTS but the table is a temp table and that
wont work.

Thanks for your help in advance. --
Austin Henderson <><
Network Administrator
  Reply With Quote
Reply


Thread Tools
Display Modes




Copyright 2006 SmartyDevil.com - Dies Mies Jeschet Boenedoesef Douvema Enitemaus -
666