As a test, I was trying to export the pubs database to Excel. There is
always one
table I couldn't export: the pub_info table. Others were OK. The error I got
was:

Hi to everybody.
I'm a newbie who imports its .xml files though the XML Bulk Load COM
Object in SQL Server 2000 and after some DTS processing, they are
exported to .txt files.

I have a table that contains the last name, first name, middle initial, and
suffix all together as one data element called "FULL NAME"; I need to have
this broken into separate data columns in my return query and have been
attempting to use CHARINDEX as a means to accomplish this ...

I am trying to "clone" a few transforms in SQL7 from a copy of the original
database into the same export files.  In other words point 2 different data
sources into the same export file.  Can I do this within the same DTS
package?

I have a DTS package that loops through a temp table of records and imports
a list of files based on these records.
I'm wondering if it's possible to check the state of the package from within
my ActiveX task that is doing the looping, to see if the user running the

I have a VB.NET application that needs to execute a DTS package.
This package includes an 'Execute Package Task' as one of its steps.  I
cannot get the 'Execute Package Task' step to run.
My package runs fine if I take out this package.

I would like to know if there's a simples way to import/export (copy) DTS
packages between servers, because I would transfer my current packages to new
production Server... There's no DTS Task to copy Packages like Jobs or
Users...

I have a dts package which is very slow to update a table.
I'm using a DDQ where in input I send some rows to update, and I call a
storedprocedure to do my update.
1 update takes 2 to 3 seconds!!!! (i can have more then 1000 updates)