I have to export date data to a text file for use on a UNIX server.  The
programmer is asking for the date field to be split up into two fields.
YYYYMMDD  and
HHMMSS

Does anyone know of an example showing how to import a delimited text
file into SQL via the DTS api in C++???  I can get this to work from VB
but when I translate it to C++ it doesn't work, even though I get a
HRESULT that succeeded.  It is so frustrating!! Short of posting the

I am using DTS Wizard to Import data from Excel to a new
table in SQL server. After import, I notice that some data
values in Excel are replaced by NULL in SQL table without
any warning or error. That makes me very nervous. It means

Using SQL server 2000 on Windows server 20003.
I need to copy table(s) from one database to another. I have created a Copy
SQL Server Objects Task to do this. However, I need to have a user run this
from Access VBA. I would like to have them input a table name, press a

Based on Sql server 2000 sp3 , I  use dtsrun command to run a structured
storage file from a remote machine and  get below errors
DTSRun OnError:  ExportData_Step?AError = -2146959361 (8007FFFF)
  Error source:   Microsoft Data Transformation Services (DTS) Package

I have finished my Database along with Tables, Views, Stored Procedures
and Constraints.
Is there an easy way to push 1 button ;-) that will export the complete
database into a SQL Script?  I want to add this to the root of the

I am pulling my hair out trying to figure out why I can't sink up dts
package events in VB.NET when referencing an RCW that is around the
dtspkg.dll.
The code in this article works fine when just referencing the dtspkg.dll

Normally when you read in an Excel file through DTS you read it in by row.  I
have a file that is setup as a cross tab report that I need to read in.  This
is how it is in the spreadsheet:
                  Jan 05

I have a text file with names, addresses, email, etc...  It contains over
700,000 records.  When I use the DTS text driver I only get just over 400,000
records.  If I Import the data into MS Access, I get the full 700,000.  I
looked at the file in at Hex editor and the row ...

DTS load jobs executed successfuly but no data.
I have dts paackages for loading data from one sql server database to
another sql server database, there are 8 tables being loaded daily and they
run by sql server agent job. I used simple simple copy transformation on all

I have to update 9 tables on my local SQL Server each night, built with the data from two remote databases (1 SQL Server and 1 FoxPro). The data in these remote databases contains duplicates.
The method I have chosen is to create a DTS package on my local machine, which creates 9 ...

I configured a computer a work to be a 2K server and installed SQL 2K on it
and I have been using it for testing purposes since 7 months now. This
morning I loged in as Domain Admin to the server and tried to access the SQL
server and I got the error message "Cannot generate SSPI ...

I have a package that I am using to take data from a table in SQL out to an
Excel spreadsheet. However, what I'd like to do is have the package put the
Excel workbook on an individual's desktop. I tried using the %userprofile%
variable but the system is not accepting that. Is ...

I have done a DTS package which pull data from a CSV file and copy the
contents to a SQL table.
On the text file source I can put a CSV file which is in another server and
when I run it from SQL enterprise it works fine.

Hello,  I had created DTS Packages long time ago and they were working fine.  
I never had any problem scheduling any of them.  However, I can not schedule
any of the packages I created a while ago or the brand new ones.  I receive
an error message and described below.  Any help ...