Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Rollback a DTS-package
- HelloWe run several DTS-packages on an SQL server 2000 during the night.Each package updates several tables by first dropping them, then creating new instances and finally copying the data from the source into them.The problem is that the connection to the source is established after the drop and the creation....
- Tags: Databases, DTS-package
- Discussion threads 2005-11-21
Additional Resources
- Free DTS Package Profiler Wizard (msi)
- DTS Profiler is an easy to use tool which can profile your DTS packages stored on SQL Server or File System. DTS Profiler will tell you many important things like package count, complexitity, and some internal information. DTS Profiler can find how many packages do you have; how complex they...
- Tags: Package, Pragmatic Works, DTS Profiler, Productivity
- Software downloads 2008-09-09
- Customize data transfers with DTS and SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and...
- Tags: tool, multitude, DTS, Microsoft SQL Server, workflow, server, FTP, scripting language
- Image galleries 2006-09-13
- Optimize the performance of Microsoft Operations Manager 2005 (MOM): Configure, monitor, and troubleshoot the DTS package
- Microsoft Operations Manager MOM uses the DTS package to transfer data from the OnePoint operational database to the SystemCenterReporting archive datawarehouse database. Archiving old data from the OnePoint database to the SystemCenterReporting database keeps the OnePoint database small and streamlined, thus improving the performance of MOM....
- Tags: Monitor, Performance, Microsoft Operations Manager, Microsoft Corp., DTS, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Download resources 2006-12-19
- DTS projects
- Hi all, I'm currently learning DTS and wanted to get some practice in package building, so as to better understand the product and packages I'll encounter in new production environments. If anyone knows a site/source showcasing a wide spectrum of DTS projects, preferably already in production, I'd be grateful for...
- Tags: czaroftime@..., DTS
- Discussion threads 2007-04-09
- DTS process automation
- I want to make the source file's name a parameter that I can pass to dtsrun. I tried using a global variable that I can refer to on the command line, however, I don't see how I can use it inside the DTS code.Please give clear informationHi,Please give me clear...
- Tags: DTS, HighTechAngel, process automation, software, sql
- Discussion threads 2005-10-11
- Execute a DTS package from a SQL Server stored procedure
- DatabaseDTS
- Tags: DTS, Execute, it management, Microsoft SQL Server, ory147@..., server
- Discussion threads 2005-04-29
- Run SQL DTS from Oracle 9i Procedure
- How can I automate a SQL Server DTS package to run within a Oracle 9i procedure. My Oracle 9i package would be the one to kick off the DTS package....
- Tags: Databases, Enterprise software, Oracle9i, Oracle Corp.
- Q&A 2005-02-16
- SQL DTS Connection - MS Excel 97-2000
- I am currently DTS with ActiveX to call Excel application to update worksheets by a macro with Excel installed at the server.I am looking for a solution of not to installed Excel at the server and looking for an alternative solution.I was looking at using DTS Connection - MS Excel...
- Tags: DTS, hardware, kaypaul@..., Microsoft Corp., Microsoft Excel, SQL
- Q&A 2005-07-28
- HOW-TO: SCHEDULE A JOB OF EXECUTING A DTS PACKAGE FROM WITHIN VB6
- Hi,I have recently created a VB6 application that provides a list of available DTS Packages on the SQL Server 2000 database to the user and allows them to execute the package. Although the function works fine, there is a need to have the task schedule to execute at a...
- Tags: DTS, dts package, fsanchez@..., job, Microsoft Visual Basic 6.0, Package, programming, sql server job scheduler, vb6
- Discussion threads 2005-11-12
- SQL2000: DTS Query Task - Return Value
- In SQL Server 2000, in DTS, a SQL Query Task executes a stored procedure that returns 0 or -1. Either value causes a Workflow property of success, but I require two different actions. I do not want to cause the package to fail for example with raiseerror. ...
- Tags: Databases, DTS
- Q&A 2006-08-19
- DTS package error Plz Help
- Hi Iam facing a problem with DTS package. and i was trying to execute the code which u gave in this sitetype casting error is coming at this lineoCustomTask = oTask.CustomTaskfull code is belowDim oPackage As New DTS.Package2Dim oConnection As DTS.ConnectionDim oStep As DTS.Step2Dim oTask As DTS.TaskDim oCustomTask As DTS.BulkInsertTaskTryoConnection...
- Tags: hari_612@..., Nothing, oConnection oConnection.Catalog, DTS.Task Dim oCustomTask
- Discussion threads 2007-06-18
- DTS package error Plz Help
- Hi Iam facing a problem with DTS package. and i was trying to execute the code which u gave in this sitetype casting error is coming at this line oCustomTask = oTask.CustomTaskfull code is belowDim oPackage As New DTS.Package2 Dim oConnection As...
- Tags: hari_612@..., Nothing, oConnection oConnection.Catalog, DTS.Task Dim oCustomTask
- Discussion threads 2007-06-18
- Implement conditional workflow in a Data Transformation Services (DTS) package
- As a SQL Server consultant, Data Transformation Services DTS is most likely your tool of choice for Extracting, Transforming, and Loading ETL data. While you may have found the data manipulation tasks in a DTS fast, easy-to-use, and flexible, you may be disappointed in the limited workflow capabilities of DTS....
- Tags: Data Transformation Services, Data Transformation Services Package, Crowe, Chizek and Company LLP, workflow
- Technical articles 2004-04-26
- Enterprise Manager, DTS 2000 - Set Maximum Characters per column.
- Hi,Enterprise Manager, DTS 2000 - Set Maximum Characters per column. I have a query which is okay when i run via Query Analyzer 2000 becuase I set the limit via Query Analyzer 2000: Tools - Options - Results - set maximum characters per columnBut when I create a DTS package...
- Tags: ismailc@..., DTS, Enterprise Manager
- Discussion threads 2007-04-26
- Customize data transfers with SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude of packages and...
- Tags: DTS, DTS Designer, Microsoft Excel, Microsoft SQL Server, server
- Blog posts 2006-09-11
- Programming DTS With Microsoft Visual C# .NET
- An already powerful development tool in SQL Server 2000 DTS can also take advantage of the .NET Framework to create DTS applications and custom tasks. The main topics covered in this webcast are - setting up the development environment; working with COM components from .NET components; loading, executing, and saving...
- Tags: Microsoft Corp., Programming, .Net, C#, Middleware, Application Servers, ActiveX/COM/COM+/DCOM, Development Tools, Databases, Software Development, Software/Web Development, Programming Languages, Enterprise Software, Software, Data Management
- Webcasts
- modify records in one sql server which is differ from anothe server by DTS?
- Hi all,currently, I've been incolved in a data migration project. The objective is synchronize the sales invoice from one server to another server by DTS! And Now, I can use DTS to tranfer data between these two servers. But I just want to appending the new invoice without duplicate records....
- Tags: SQL, jle@..., DTS, server
- Discussion threads 2007-07-02
- Customize Data Transfers with SQL Server
- DTS is a set of related tools that enable you to manipulate or transform data from various sources. To create a DTS package, you can use the DTS wizards to move data. You can also use the more advanced DTS Designer, which lets you create a multitude...
- Tags: Database, Package, Microsoft SQL Server, Server, DTS, Microsoft Excel, Storage, Databases, Microsoft Office, Office Suites, Software, Hardware, Enterprise Software, Data Management, Steven Warren
- Blog posts 2007-12-19
- SQL 2005 DTS
- I've tried everything I can think of. Can't get DTS to work in SQL Server 2005. I get this error every freakin time!'Violation of PRIMARY KEY constraint 'PK_Alerts'. Cannot insert duplicate key in object 'dbo.Alerts'.Sometimes it's a foriegn key. I can't figure this out. I try to have DTS drop...
- Tags: Databases, DTS
- Discussion threads 2006-06-26
- << Previous
- page 1 of 1
- Next >>
