Scheduling a DTS Package
HiOn 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?ThanksP
View Answer
| May 13 2008 11:48 AM GMT
| asked by
Pmwhelan
DTS Package Scheduled Task, SQL Server Enterprise Manager, SQL Server
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
View Answer
| May 7 2008 5:14 AM GMT
| asked by
SRI HARSHA
SQL Server Agent, DTS, SQL Server 2000
DTS schedule package
How can I see the scheduled run time of an existing DTS package?
View Answer
| Apr 30 2008 7:09 PM GMT
| asked by
Hoverman
SQL Server 2000, DTS, Data Transformation Services
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...
View Answer
| Apr 30 2008 5:51 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server upgrade, DTS, SQL Server 2005
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 SP1and 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...
View Answer
| Mar 14 2008 7:31 AM GMT
| asked by
MNA
SSIS, SQL Server 2005, DTS
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 the two...
View Answer
| Mar 11 2008 10:20 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server, Business Intelligence (BI), DTS
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,...
View Answer
| Feb 6 2008 9:42 AM GMT
| asked by
Sandy55
SQL Server 2000, AS/400, DTS
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??
View Answer
| Jan 11 2008 3:35 PM GMT
| asked by
JimmyIT
SQL Server 2000, DTS, SQL
DTS error after deleting xls file with script
All,After I have deleted a xls file using an ActiveX script the DTS Package fails because the file is not there. I then have to go into the properties of the task and go to the destination tab and click the create button. The I have go to the Transformation tab and then run the package for it to...
View Answer
| Jan 9 2008 5:11 PM GMT
| asked by
Gdckboyer
SQL, DTS, XLS
