|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Generate data entry and reporting .NET Web apps in minutes, straight from your database. Read our FREE whitepaper “Build Web 2.0 Applications Without Hand-Coding” Download now! |
|
#1
March 14th, 2004, 07:20 PM
|
|||
|
|||
sql query
Hi pabloj and all others who tried helping me...
 I tried a few things and one of them worked!! pabloj...i wasn't necessarily trying to use DTS...had tried it before but wasn't specifying the data source right!! The solution is actually very simple...import the .dat file exactly as you would had it been a text (flat) file. But there was a catch even to this one 'cuz my file had columns that could be identified only via their respective positions and this problem got solved while solving the first problem of choosing the data source. Choose the data source type as fixed fields, then it automatically previews the column values as in the .dat file and all you need to do is specify the columns!! As simple as that!! And do the necessary transforms in order to get the column names right instead of col01, col02, etc.  Last edited by g_janhavi : March 15th, 2004 at 03:40 AM. Reason: Closing problem
|
|
#2
March 15th, 2004, 03:23 AM
|
||||
|
||||
|
Are you using DTS ?
__________________
My blog about OpenSource Databases PDF tutorials about OSS databases, DBMonster ... Please contribute to Open Source Development, fill bug reports!!! Developer Shed eSupport Commented my.ini/my.cnf (PLEASE ADD YOUR OWN CONFIG TRICK) An introduction to database normalization Natural or Surrogate key Custom ordering for your results Correlated and uncorrelated subqueries Don't turn your outer joins into inner joins
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > sql query |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
