Hey. I've successfully migrated all the packages from server\instance1 to
server1\instance1. I read in one of the articles I've to change
MsDTSSrvr.ini.xml file to see the migrated packages in SSMS. I did it and now
i see the packages.

sql2k sp4
Howdy all. All of a sudden, my DTS Package is totally unusable. If I try to
run it or design it, I get "unspecified error". I have verified that there
is no corruption in both MSDB and Master. Ideas?

I am new to SQL.   Is there way to copy DTS Packages from one instance of
SQL Server to another?
   Thanks,,,, Cliff

I am trying to use DTS to copy from an Excel file to a table (SQL 2000).
The table has a primary key (say ID). As might be expected, when a
duplicate key is detected, it terminates the copy. With Access one could
use First/INTO/Group and have the copy just skip the duplicate. I ...

I'm trying to move some data from a tab delimited text file into a SQL
Server 2000 database table using DTS and have run into a problem
converting text data into smalldatetime.  The format for the dates in
the text file is CCYYMMDD, all text fields are double quoted.

I want to set up DTSRun to be executed by some particular users so that they
can update specific cubes on demand (e.g. when they have just added some
journals and want to see the effect on account balances in their cube).
I have got DTS running (using encrypted command line ...

i need really your help with the next error. haven't idea what is the
problem.
----
DTSRun OnError:  DTSStep_DTSExecutePackageTask_1, Error = -2147467259

I'm new to integration services.  
I want to create a centralized reporting system for our customers.  Some
customers have up to 1,000 sites and some are expected to grow past 2000
sites.  The sites are running POS applications and I want to extract the POS

2 questions.
First, lets say I have a network share mapped to a drive letter on my machine.  Now I set an Excel or Text file connection to a file
on this mapped network drive and save the package.
If someone opens it on another machine with differently mapped drives, will the DTS ...

I am using bcp and xp_cmdshell to produce output text file in sql server
2000. The size of the output file is so big. Is there any way to break the
file into small files (for example 500 records per each file) ?
Is there any option using the xp_cmdshell?

I have a data pump task in one package that uses a copy column
transformation.  I would also like to add this same transformation to another
package.  Is there any easy way to copy the transformation and place it in
another package or am I stuck doing the mappings all over again? ...

Hi All,
I have local Package DTS which logged in as the user runs Dandy.
But when Scheduled gives me this error:
MESSAGES:    The job failed.  Unable to determine if the owner (XXXX\YYYY) of

I have a package which load a flat file to a SQL server table and runs fine
in SQL 2000.
There is a column in the flatfile "orderdate" which has the data like  
'20060423', I load this column data  to the 'Orderdate' column of the sql

SQL 2005 SSIS
This should be simple, but its not.  I have a simple package that
selects data from one server and inserts it into another.  It works
interactively but I cannot get it to run scheduled.  I have tried

For a DTS package; Copy SQL Server Objects Task
Source, pick a database on server1
Destination, pick tempdb on server1
Copy (with these selections):