DTS

[Faithalone1]

I have an access 2000 table as the source to a DTS package. The columns in the table are all datatype 'text'.&nbsp;&nbsp;I need to transform some of the fields to integer as well as accept nulls.&nbsp;&nbsp;How do I do this in DTS?&nbsp;&nbsp;If a script is involved please supply a sample of the code.&nbsp;&nbsp;Thanks. <br>&nbsp;&nbsp;<br>&nbsp;<br>

 

[Faithalone1]

Never mind. I had bad data in the access table.&nbsp;&nbsp;Once it was fixed the DTS worked as intended.&nbsp;&nbsp;