Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Wanet Telecoms Ltd on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: goman
  • Order by date
  1. goman

    DTS Scripts

    Is there any way of creating a DTS script in a text editor and then importing it into DTS?? For example, I am importing from multiple Fixed Width files, each having 100+ columns in each table/file. I have the field width information in a separate table and would rather not have to retype in...
  2. goman

    BCPing in a fixed width file

    I am bcp-ing in a fixed-width file. A lot of the fields are blank (space filled). When I bcp the file in (the table fields are varchar) how can I have the table store a zero length string instead of spaces?? To this point I have had to run update queries. Is there a way to trim on the way in??

Part and Inventory Search

Back
Top