change .dat to a .txt

[balistikb]

Is it possible to change a .dat file to a .txt file in a dts? I tried but it doesn't recognise .dat.

 

[JayKusch]

If you are just trying to change the name of an existing .dat file to a .txt file, you could use the xp_CmdShell option as in ...

EXEC xp_CmdShell 'Ren C:\Myfile.dat C:\Myfile.txt'

Thanks

J. Kusch

 

[balistikb]

Can you explain what that command is doing? Break it down so I can understand.
Thanks, I am new to this.

 

[JayKusch]

It is shelling out to DOS and running a RENAME command on your file. It is changing it from a .DAT to a .TXT

Full command should be ...

EXEC master..xp_CmdShell 'Ren C:\Myfile.dat C:\Myfile.txt'

You would of course change the Path and file name to correspond to your file name.

Wrap this in a "Execute SQL Task" object w/in your DTS package and you are good to go!

Thanks

J. Kusch