As for the insert , the problem seems to be that you have defined an incorrect row terminator. You should be using ‘\n’ instead of ‘/n’.
To rename the file, try something like this:
<pre>declare @command varchar(1000)
set @command = ‘rename c:\table.csv table_old.csv’
exec master.dbo.xp_cmdshell @command, NO_OUTPUT
With SQL Server 2005 and 2008 the use of xp_cmdshell is turned off by default.
<a href=”http://msdn.microsoft.com/en-us/library/ms190693.aspx”>Enabling xp_cmdshell Option</a>