Hello All,
I am Using SqlServer 2000 DTS package for transformation of data from a Text
file to a table in the SQL server.
The data, in the text file is separated by fixed length Commas.
Questions
1. My Source data in the Text File consists of a numbers like (999.99). So
while transformation of data,it has to input with Null into the
Destination Database table. How to do this.
2. Is there any restrictions in maximum number of columns of data to be read
from the text file.
Thanks
balachandran