SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Data Extraction
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

eem_2055
Yak Posting Veteran

Philippines
69 Posts

Posted - 11/13/2007 :  06:40:31  Show Profile  Reply with Quote
Guys can you help me to extract my database data to text files using different format:

sample
ClientId 9 ClientNo 12

How can I extract ClientNo with a length of 12 to ClientID with a length of 9 to text files.

SwePeso
Patron Saint of Lost Yaks

Sweden
30265 Posts

Posted - 11/13/2007 :  06:54:10  Show Profile  Visit SwePeso's Homepage  Reply with Quote
Huh?
This is clear as mud, right?

Please post some sample data and explain again.




E 12°55'05.25"
N 56°04'39.16"
Go to Top of Page

khtan
In (Som, Ni, Yak)

Singapore
17650 Posts

Posted - 11/13/2007 :  07:47:11  Show Profile  Reply with Quote
use BCP, DTS etc.


KH
Time is always against us

Go to Top of Page

arorarahul.0688
Posting Yak Master

India
125 Posts

Posted - 11/13/2007 :  07:59:50  Show Profile  Reply with Quote
use Dts in case of sql server 2k

ad ssis(sql server integrated service) in case of sql server 2005

Rahul Arora
MCA 07 Batch
NCCE Israna, Panipat
HRY, INDIA

######################
IMPOSSIBLE = I+M+POSSIBLE
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.08 seconds. Powered By: Snitz Forums 2000