Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ravisankarnbr
Starting Member
3 Posts |
 Posted - 2011-04-01 : 00:15:00
|
| 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 command bcp used in DTSDB.dbo.SP_name out 'E:\App..\..\Data\sample.txt' -C -t0x1F -r0x1E -S Servername -U username -P password -CRAWI'm facing permission issue with the bcp command since the SQL users who is running this DTS package is having different permissions.Can I use any alternative other than BCP command in my DTS package for doing the export functionality. ?thanks for you valuable time. |
|
|
|
|
|
Export data from dts package