DTS

Error copying indexes in DTS package

I have a DTS package in SQL Server 2000 that copies data from one database to another.  The copy indexes option is checked.  For almost a year this has worked fine until recently where the job is ending successfully but the indexes are not copying over.  At first it was maybe once or twice a...

DTS: Export to Excel

I'm exporting a simple table to Excel but my problem is that the table columns will change every month since the column names will list month names (ex. May2009). Can I use ActiveX to dynamically create the transformation source? Please help!

Tool for migrating DTS to SSIS

What is the tool for migrating dts to ssis.And how effective it works.And I want migtate 500DTS packages to ssis how much time it will take?

Troubleshooting a DTS job failure on SQL Server

I have a DTS job that failed on my SQL Server, but it doesn't have a failed message in the job history. I checked out our DTS package log, and it is empty. How can I troubleshoot this DTS job failiure?

Transform Data task properties not opening.

In my analysis manager, data transformation packages, i open a package and try to open the properties of Transform Data task. Whenever i am trying to open the properties the analysis managergot hungs.l The properties not opening. I am using MS SQL server 2000.

Executing DTSX from VB.NET 2003

We converted form SqlServer 2000 to 2005. We had dts packages which were used to import Excel data into the database. We re-created new dtsx packages to replace the old dts packages where they sit on a local drive. Our VB.NET 2003 application used to be able to run the old dts packages but we...

How to move a DTS from sql 7 to a server running sql 2005?

I have several dts packages that are running on a sql 7 server, I need to move them to a server running sql 2005. Any suggestions on how to do this? Thanks

DTS Package Schedule runs only once, Status shows executing

Hi, I have set up a DTS Package and schedule it to run every 2 minutes (to prove it will run regularly). Unfortunately the package only runs once. The process only takes a few seconds. The job status shows "Executing Job Step '1 DTS Package1'" Is there something I'm missing? Gabs

DTS of TEXT to BLOB or CLOB

Is there a maximum size to DTS from text to a Blob or clob ?

Copying DTS packages from SQL Server 2000 to SQL Server 2005

I am in the process of migrating from SQL Server 2000 to SQL Server 2005. We have several hundred DTS packages. Converting to SSIS will take many months, so we are planning to run the DTS packages under 2005. Is there an easy way, or a utility, to copy the DTS packages from one server to another?

dtexec scripts just deleting data

since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the import\export wizard are simply deleting all data in my target tables (when run via. dtexec), Yet they work ok from the wizard, and worked ok a few weeks ago. I don't understand what this...

Using DTS objects for scripts to alter SQL Server password

Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?

Scheduling a DTS Package

Hi On MS Windows Server 2003 I have a DTS Package in SQL Server Enterprise Manager. The DTS package runs fine in SQL Server Enterprise Manager. How do I add that DTS package as a scheduled task? Thanks P

How to Schedule jobs in DTS in sql server 2000

I have got 7 jobs in my sql server server agent, now i want them to run simultaniously one afer the other using DTS, is it possible,if yes how can i do it

DTS schedule package

How can I see the scheduled run time of an existing DTS package?

Looking for best approach to upgrade SQL Server 2000 databases to SQL Server 2005

I will be upgrading a number of SQL Server 2000 databases to SQL Server 2005 and was wondering what database objects I have to worry about? I believe to run Data Transformation Services (DTS)in 2005, I will have to have legacy installed. Is that correct? Other than that, should there be any...

Unable to execute the saved SSIS package.

I have two servers server1 and Server2 both has SQL Server 2005 installed.Server1 has Enterprise Evaluation Edition SP1 and server2 has Workgroup Edition SP2.Since server2 has workgroup edition I cannot open the saved SSIS package in server2. So I connected from server1 created a DTS package and...

Linking SQL Server databases to create DTS packages

I want to create a DTS package in SQL Server for the following problem: 1. Table T1 in Database DB1 in server1. 2. Table T2 in Database DB2 in server2. 3. Table T3 in Database DB3 in server3. The DTS package will be created in DB3. I need to copy data from T1 and T2 based on T1.ID = T2.ID, from...

Insert and update DB2 from SQL Server 2000 using OLEDB

I am using AS/400 and SQL Server 2000 and trying to insert and update from SQL Server. When I run a DTS from SQL Server 2000, SQL Server 2000 is able to read the table from AS/400 but when I run a DTS from SQL Server 2000 to insert or update a table on AS/400, it does not do anything. No error,...

Need to create SQL DTS Package

We are using SQL 2000 DTS Packages and I want to create a DTS Package which can copy only all text file names from folder(source) to SQL table column(Destination). Also i want to write number of rows in particular text file to SQL table. DTS or Procedure or Activex Script??