Does anybody knows what is the max number of rows when using BCP and if there
is any way to change it??

I have a DTS package that I have had to manually run because it got blocked
by XP Security.
Now XP is even blocking the copyfile command  step when I manually run it.
How do I turn off the XP Security or how do I change the scripts to run.

can anyone point me to a list of the various DTS.Connection properties. I
need to know which properties to set to import a fixed field file.
Thanks,
Erik

I am currently still looking for a solution to my problem, anyone have any
ideas?  This is how far I came:
Hi Darren,
Well, I am testing by just double clicking in windows, but when the script

I have a strange problem that I am having trouble troubleshooting. I need to
execute a SQL commend against an Oracle database using DTS. I created a
'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL'
task on that connection. When executing the task I get the ...

Microsoft SQL Server  2000 - 8.00.760 (Intel X86)
Hi,
I've setup a SAP BW OLE DB Provider to read data from a
SAP Query with a Transform Data Task.

I am importing company information from a third party who adds a @ sign
in front of certain tickers.  Is there a way for me to remove this sign
while doing the import?

I've got the problem. I created DTS package that copy data from SQL Server to
the text file. The DTS successfully execute from 'Data Transformation
Services', but when DTS schedule to run in SQL Server Agent it gives me the
error.

Currently we get data from more then 200 different sources and all of
our vendors provide data in different file formats. The problem is we
have more then 100 DTS packages now and the maintainance is very
diffucult.

Can anyone tell me how can I send email through stored procedure in sql
server ? I want to send attachment with this email too.
TIA

Hi ,
I have an existing MI System that uses a third party command line
application to retrieve and store data in text files , i want to automate
this using DTS . The third party command line applications expects one param

I have 2 servers , so server web and sql server
I not executing um package in page asp
When open browse page , o job failed.
I create user no AD , with permissions this page

I have build my own custom transformation and tested it by copying a source
table with 50000 records to the destination table. The records were copied in
a strange order. Is this a normal SQL server behaviour, or is this issue
related to my custom transformation?

I need to import an Oracle Database into SQL Server 2000.
I know this can be done easily using DTS but I do not have access to the
Oracle Database, I only have an Oracle Database Export File.
The Export file has been generated using SQL*Loader.

I have a master control package that execute a bunch of other control
packages which then execute actual DTS code modules.
The problem is that a specific DTS packages fails and then returns a fail to
the first calling control package which then traps the failed state and then