Browse Site by Tags - Kerala Microsoft Users Group

Export data to file fom dts package

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...

Posted to Database Zone (Forum) by Ravisanker on 04-01-2011

Data Transformation Service (DTS)

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.

Posted to Database Zone (Forum) by Ravisanker on 03-02-2011

Sql Scheduled Job

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...

Posted to Microsoft Technologies (Forum) by Ravisanker on 10-18-2010