Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Replacing a char data type with numeric in package

Author  Topic 

mdhingra01
Posting Yak Master

179 Posts

Posted - 2005-12-29 : 13:53:32
I have a table structure that is being used in a number of packages in a create statment. I just noticed that one of the fields should be a numeric type in stead of a char, is there a way to run a search and replace on the Create statement either within a DTS package or through a sp or other admin function?

Thanks
   

- Advertisement -