Check for Data type before a DTS package runs | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Check for Data type before a DTS package runs

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 Brent W Peterson
http://d4data.com
If you know about ActiveX script then you can achieve the same, to write in VBscript. Satya SKJ
Moderator
http://www.SQL-Server-Performance.Com/forum
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
]]>