SQL Server Performance

Check for Data type before a DTS package runs

Discussion in 'SQL Server DTS-Related Questions' started by 66cooper, Mar 19, 2004.

  1. 66cooper New Member

    I have a SQL job imports a flat file everynight. I copy the entire file into a table, then transform 5 columns to int's for the purpose of searching.

    I have just started to get a error on one column, is there a way to remove/update all non int values before I do my transformation?

    Is there a non int data type that I can search on and order by?


    Brent W Peterson
  2. satya Moderator

    If you know about ActiveX script then you can achieve the same, to write in VBscript.

    Satya SKJ
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.

Share This Page