I've read and followed the article http://www.sqldts.com/default.aspx?234 but
I _still_ can't get the result from the stored procedure's output parameter
to populate my DTSGlobalVariable -- and it's driving me nuts! I 've tested
the stored procedure in Query Analyzer and it's ...

I was wondering how i could use dts to import accessfiles and then archive
them to another folder. I've read some examples on sqldts.com but i still
can't figure it out.
Basically this is what i want:

I have a data pump task which pumps data from a source to destination,I'd
like to check every single field in each row and if any of them is null,I'd
like to update the last field in the row and skip other field processing in
the row and move to the next row.

In configuring log shipping, i have been attempting to follow directinos and
set up a job to transfer logins frm the Production server to the standby
server.  This job includes a step that runs a DTS package that uses the
Transfer Logins Task step.  This step fails with an ...

I'm processing a flat file into a database, and it has disparate records...
i.e. start positions for information are not the same for every record.
Now, with Oracle, I could use SQL*Loader to process various load formats...
but does DTS handle various load formats?

I have to Update an Access DB Table from Values out of an SQL Server Table,
where both have an ID column (SQL Server Identity).
Some rows in the Access Tabele have to be updated from the SQL Server table
as the source.

I have an application that uses several stored procedures.  I want to create
an installation program for this application and within the installation
script add the stored procedures to the database.
I have created executables from DTS packages and called them from an

I have an Execute Package which calls another package and passes its inner
package global variable into the child package's global variable ,I  have a
global variavle in the master package which I like to set to execute package
task's inner package global variable.I have done this ...

I have a question, how can I export the table into a csv file and couple
column need merge into a column while export to the csv file.
Source colume: partno,material, color, grid, screen
CSV file: partno, types

I do this to backup the database on our production server
BACKUP DATABASE [DP2] TO  DISK = N'D:\mssql\data\MSSQL\BACKUP\DailyDbBackup'
WITH  INIT ,  NOUNLOAD ,  NAME = N'DP2 Backup Job',  NOSKIP ,  STATS = 10,
NOFORMAT DECLARE @i INT

Hello, all.  Running SQL 2K.  I have several DTS packages
that I've always been able to open successfully without a
fuss.  Since a few days ago, I've been getting a DTS
Designer Error when trying to open my packages.  The error

I've copied the table structures of a replicated DB from
another SQL Server.  I have no need to use replication
with this new DB.  When attempting to add a record to any
of the tables, I receive the following error: "Invalid

I have set up a job that executes numerous DTS packages on a nightly
basis to transfer a large amount of data from a legacy database to SQL
Server 2000. The job is expected to notify our department if the Job
has failed or succeeded  via email. Every now and again I get the

I have database with some relationships
One of them declare as one to many.
In order to import the data correctly i need to import first the table with
the primary key and after that the  table with the foreign key.

I have a DTS job on a Windows 2000 AS server and SQL Server 2000, which needs
to unzip a zip file as the first step of the transform and load.
My understanding is that Windows 2000 AS Server has a base function to unzip
items that you click on (in much the same way that XP does).