Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
eem_2055
Yak Posting Veteran
69 Posts |
 Posted - 2007-11-12 : 05:42:46
|
Hi guys!How can I extract data from a SQL server 2000 to TEXT Files. On which the data length that I have is different from the new format.sample: database1: employee_ID = 10 database2: ID_employee = 8May I know what query can I execute to provide an 8 length for the incoming database?Thanks! Hope u'll help me! |
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-12 : 05:56:51
|
| What program can I use to extract data from SQL server 2000 to TXT files? And how can I set the length of the fieldname from the source to a destination since there is a mismatch with it's length. |
 |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-11-12 : 06:40:00
|
Read about BCP
E 12°55'05.25"N 56°04'39.16" |
|
|
|
arorarahul.0688
Posting Yak Master
125 Posts |
Posted - 2007-11-12 : 06:43:05
|
| in sql server 2000 you will have to use (DTS) data transfer services just go through thatin sql server 2005 you can useBIDS(Buisnes inteligence development studio) for this purposesearch on web data transformation from text file to sql table using SSISsql server integrated servicesRahul Arora MCA 07 BatchNCCE Israna, PanipatHRY, INDIA######################IMPOSSIBLE = I+M+POSSIBLE |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-12 : 07:06:34
|
| Thanks peso! |
|
|
|
eem_2055
Yak Posting Veteran
69 Posts |
Posted - 2007-11-12 : 07:10:45
|
| may I know on how to use case using data in my database? |
|
|
|
|
|
|
Data Extraction