Showing related tags and posts accross the entire site.
Hi I'm using SQL SERVER 8.0 , I have an DTS package that holds the functionality for exporting data from a SQL table to a .TXT file. Currently BCP command is used to do the functionality. Below is the bcp cmd used in DTS DB.dbo.SP_name out 'E:\App..\..\Data\sample.txt' -C -t0x1F -r0x1E -S...
Hi I'm having a DTS Package succesfully installed in a SQL machine, now I needed to move the DTS to another machine. Is there any option to Export the package, if the systems are not in the same network. Can anyone please advice.
Hi I'm new to SQL Scheduled Jobs, My Query is I'm having a DTS package (ex : DTS1) and one job (ex: SqlJb) is scheduled for running this DTS package overnight. Now I want to Edit the same job say Sqljb and to run another DTS package say DTS2 . How to edit an SQL JOB for redirecting to another...