I am using SQL Server 2000 on Windows 2000 server. Here is my problem:
@String = 'word1word2word3word4word5' - This value is passed to Stored
Procedure from the script.
Column1 in a table1 has many rows with "words" . One row in this column1

I have a stored procedure (which uses the sp's sp_OACreate,
sp_OAMethod, etc.) that should execute a DTS-package on the server.
This DTS-packages exports data from SQL Server database to an existing
Access 97 database.

I have some tables that keep failing when I try to copy them to another SQL
server using DTS. I've identified a pattern that the first failing row in
the problem tables always has a comma in one of the nvarchar fields. I'd
like to try to write a dts package that would filter out all ...

Is the /A parameter from a DTSRUN command automatically assigned to the
global variable defined in the DTS package?  If not, how would this be
done?  I'm trying to pass path/filename information to change the
datasource text file, but the global variable that I use to assign to

Can I have an example about an "working" DTS package including the steps
involved, error checking and some notification procedures used?
Thanks

I have an execute package that has numerous transform tasks.  When the
package is run independently, it works fine.  When I execute the package from
within another package, I receive an error stating "Execution was canceled by
user."  I've seen the knowledge base article about ...

when imported fixed length text file to database the result is not
completed, not all rows in the text file were imported by DTS.
What happend with this....

I am going bonkers trying to copy tables from one SQL Server to another. For
example, for one table, when I try to copy it from Svr A to Svr B I get the
following error:
Error at destination row number 7. Errors encountered so far in this task:

Is there anything wrong with this?
Or a better way to do this?
Ryan
Function Main()

I have a DTS package that queries couple of tables and exports to a flat
file. It runs good if I provide all the parameters. But if I use ? in the
where clause it gives me the following error:
"No value given for one or more parameters"

As we know we can design package than does table->table conversion. But how
to get a conversion of all tables -> all tables?
thank you!

I need a help!!
How to download files in DTS package?
Tanks
Joao

I tried to copy all objects from one SQL Server DB to another. The target DB
was new with nothing but the default sys tables. When I ran the DTS task it
looks like it copied all the tables and then failed with the error shown
below. None of the views or SPs got copied? Any ideas on ...

I want to report the row counts for adds, changes, and deletions that occur
in several stored procedures. I have a stored proc that's invoked by an
ExecSQLTask, and global variables set up to pass the row counts from the
ExecSQLTask to a reporting ActiveX script. But the rowcounts ...

I'm calling my stored procedure through a lookup in my activex code ,but it
gives me this error:
The statement has been terminated
When I call the sp from outside (for isntance from Query Anakyzer) it