I Agree use the FileTable Feature much better and easier to maintain.

use somthing like this

select REPLACE( 'SL9975-A-A' , '-A' , '' )

Try using

exec @result = master.dbo.xp_cmdshell 'dtsrun /E /SMyServer /Ntest_dtsrun'

Hi

We do something similar and we have to sp one to disable FK and one to enable Fks

Heres the scripts

if exists (select *...

You could store all the dev and production settings in a table on a dd in sql server and then execute a Store procedure from the DTS package to get...