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 [...]
Answer Question
| September 10, 2009 2:18 PM
DTS, Indexes
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 [...]
Answer Question
| September 10, 2009 2:18 PM
DTS, Indexes
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!
Answer Question
| July 3, 2009 7:55 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft 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!
Answer Question
| July 3, 2009 7:55 PM
ActiveX, DTS, DTS Import/Export Wizard, Microsoft Excel
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?
Answer Question
| April 7, 2009 5:48 AM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, 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?
Answer Question
| April 7, 2009 5:48 AM
Data Transformation Services, DTS, SQL Server Integration Services, SQL Server migration, SSIS
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?
Answer Question
| February 4, 2009 6:40 PM
DTS, DTS packages, SQL Server DTS
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?
Answer Question
| February 4, 2009 6:40 PM
DTS, DTS packages, SQL Server DTS
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.
Answer Question
| March 10, 2009 6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
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.
Answer Question
| March 10, 2009 6:34 AM
Analysis Manager, Data Transformation Services, DTS, SQL Server 2000, SQL Server Analysis Services, SSAS, Transform Data task
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 [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, 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 [...]
Answer Question
| December 16, 2008 8:26 PM
DTS, DTS packages, DTSX, Excel import/export, Microsoft Excel, SQL Server 2000, SQL Server 2005, SQL Server upgrades, VB.NET 2003
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
Answer Question
| September 15, 2008 4:15 PM
DTS, SQL Server 2005, SQL Server 7.x, SQL Server migration
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
Answer Question
| September 15, 2008 4:15 PM
DTS, SQL Server 2005, SQL Server 7.x, SQL Server migration
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
Answer Question
| August 21, 2008 5:43 AM
DTS, DTS packages
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
Answer Question
| August 21, 2008 5:43 AM
DTS, DTS packages
DTS of TEXT to BLOB or CLOB
Is there a maximum size to DTS from text to a Blob or clob ?
Answer Question
| August 29, 2008 7:55 PM
BLOB, CLOB, Data Transformation Services, DTS
Is there a maximum size to DTS from text to a Blob or clob ?
Answer Question
| August 29, 2008 7:55 PM
BLOB, CLOB, Data Transformation Services, DTS
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 [...]
Answer Question
| June 24, 2008 7:11 PM
DTS, DTS packages, SQL Server 2000, 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 [...]
Answer Question
| June 24, 2008 7:11 PM
DTS, DTS packages, SQL Server 2000, SQL Server 2005
dtexec scripts just deleting data
since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the importexport 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 can be caused [...]
Answer Question
| September 20, 2008 10:14 PM
DTEXEC, DTS, SQL Server Express, SQL Server Express Manager
since reinstalling SQL Server Express, and SQL Server Express Manager, the dts scripts I have created with the importexport 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 can be caused [...]
Answer Question
| September 20, 2008 10:14 PM
DTEXEC, DTS, SQL Server Express, SQL Server Express Manager
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?
Answer Question
| June 9, 2008 3:22 PM
DTS, Scripting, Scripts, SQL Server
Is it possible to use DTS objects to create scripts to alter the SQL Server password I assigned when I installed the server?
Answer Question
| June 9, 2008 3:22 PM
DTS, Scripting, Scripts, SQL 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
Answer Question
| May 14, 2008 11:48 AM
DTS, DTS Package Scheduled Task, SQL Server, SQL Server Enterprise Manager
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
Answer Question
| May 14, 2008 11:48 AM
DTS, DTS Package Scheduled Task, SQL Server, SQL Server Enterprise Manager
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
Answer Question
| May 7, 2008 5:14 AM
DTS, SQL Server 2000, SQL Server Agent
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
Answer Question
| May 7, 2008 5:14 AM
DTS, SQL Server 2000, SQL Server Agent
DTS schedule package
How can I see the scheduled run time of an existing DTS package?
Answer Question
| May 1, 2008 7:09 PM
Data Transformation Services, DTS, Schedule Performance Index (SPI), SQL Server 2000
How can I see the scheduled run time of an existing DTS package?
Answer Question
| May 1, 2008 7:09 PM
Data Transformation Services, DTS, Schedule Performance Index (SPI), SQL Server 2000
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 problems with stored [...]
Answer Question
| May 2, 2008 5:51 PM
DTS, SQL Server 2000, SQL Server 2005, SQL Server upgrades
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 problems with stored [...]
Answer Question
| May 2, 2008 5:51 PM
DTS, SQL Server 2000, SQL Server 2005, SQL Server upgrades
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 saved it.After this I opened the package by [...]
Answer Question
| March 17, 2008 7:31 AM
DTS, SQL Server 2005, SSIS
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 saved it.After this I opened the package by [...]
Answer Question
| March 17, 2008 7:31 AM
DTS, SQL Server 2005, SSIS
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 [...]
Answer Question
| March 12, 2008 10:20 PM
Business Intelligence, DTS, SQL Server
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 [...]
Answer Question
| March 12, 2008 10:20 PM
Business Intelligence, DTS, SQL Server
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, [...]
Answer Question
| June 29, 2010 9:42 AM
AS/400, DTS, SQL Server 2000
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, [...]
Answer Question
| June 29, 2010 9:42 AM
AS/400, DTS, SQL Server 2000
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??
Answer Question
| February 22, 2008 3:35 PM
DTS, SQL, SQL Server 2000
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??
Answer Question
| February 22, 2008 3:35 PM
DTS, SQL, SQL Server 2000
