I have a small table with 34 rows and 4 columns that I need copied from one server to another. Everytime I perform the copy with data, everything comes over fine except for the 3rd column which brings back 'NULL' in every row?! I don't understand because the content came over for every other column, but this one. This column has datatype=char, length=5000, Precision=0, Scale=0. The data that is typed into this column is a set of numbers with spaces in between, like this: "4 502 98".
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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
DTS object copy returned nulls in one column
- Thread starter lory
- Start date
Similar threads
- Locked
- Question