Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- SQL DTS to Check for TERADATA password expiry
- How can I check for the TERADATA password expiry 1 week before expiring via SQL DTS?
- Tags: Programming languages, kaypaul@..., SQL DTS, Teradata, SQL, password
- Discussion threads 2007-08-11
- SQL DTS Task - Dynamic Properties Task
- I intend to use DTS task called Dynamic Properties Task. Where can I get more info and examples on how people used in production for batch processing.What are the limitations or FAQ to look out for before implementing?
- Tags: DTS, DTS Task, Dynamic Properties, Dynamic Properties Task, hardware, kaypaul@..., SQL, SQL DTS
- Q&A 2005-07-28
Additional Resources
- 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
- 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
- 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
- Step-By-Step: Learn the basics of using DTS in Microsoft SQL Server
- DTSAbout Sql Server 2000 DTS
- Tags: DTS, jayapragadeesh@..., Microsoft Corp., Microsoft SQL Server, networking, server, Step-by-Step
- Discussion threads 2004-12-20
- 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
- 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
- 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
- DTS & SSIS Diagrams
- Tim:I've asked this question on a couple of boards and got no response thus far.What form, file, language etc are the DTS & SSIS diagrams in and how do I get at them?I would like to access the actual graphic file and reuse it on another MS Program PopflyAny insight...
- Tags: Databases, john.webb@..., SSIS, DTS
- Discussion threads 2007-11-09
- 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
- SQL DTS
- can i migrate the Excel file into the SQL database through the DTS where the fields are different.. (source and destination.)Like the fields which are not matching in destination file..Google it.http://support.microsoft.com/kb/321686
- Tags: Programming languages, Databases, aluriprasanth@..., SQL
- Discussion threads 2007-07-26
- SQL Bundle (zip)
- The industry standard toolset for working with SQL Server 2000/2005 databases. Red Gate's SQL Bundle includes: - SQL Compare for comparing and synchronizing SQL database structures - SQL Data Compare for comparing data in SQL databases - SQL Packager for packaging databases so installing, deploying and updating a database is...
- Tags: SQL, Programming Languages, Databases, Software Development, Software/Web Development, Enterprise Software, Software, Data Management
- Software downloads 2006-03-01
- SQL 2000
- Hi there Can anyone tell me how to do the followingI have a stored proccedure in sql 2000 to send an email on a scheduled job I want to run, however I want to have the output of the job added into the email,I have used the BCP command in...
- Tags: DTS, DTS job, e-mail, job, software, SQL, tim.williams@...
- Discussion threads 2005-10-05
- MSDN Webcast: SQL Server 2005 Masterclass: An In-Depth Look at Integration Services (Level 300)
- Data Transformation Services DTS was introduced in Microsoft SQL Server 7.0 to provide a way to move data between different databases and systems. In SQL Server 2005, the DTS engine is named SQL Server Integration Services, and it provides an easier way for the developers to develop and manage this...
- Tags: Microsoft Developer Network, Webcast, Microsoft SQL Server, Microsoft Corp., Microsoft SQL Server 2005, Databases, Enterprise Software, Software, Data Management
- Webcasts 2005-11-15
- 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
- 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 Server DTS
- You may want to try SQL Server's Data Transformation Services DTS. If you install the Oracle Client on your SQL Server, you will be able to use create connections in DTS to both systems and transfer data between them. Once you have your DTS tasks built and tested,...
- Tags: agg_bcn@..., Data Transformation Services, Microsoft SQL Server, Oracle Corp., programming, server, xml
- Discussion threads 2005-07-06
- DTS Designer (Customize data transfers with DTS and SQL Server)
- take us into your system with a text cartoonicon link to explanation {chapter/book/cartoon} thenwhen we are in we will see how it works !!!!!Don't bother, MS have killed it.With 2005 it's now SSIS, completely changed.Note you do get a wizard to migrate existing packges but it may stumble on complex...
- Tags: DTS, DTS Designer, hardware, info, lawrephord10@..., Microsoft SQL Server, server, SSIS, tutorial
- Discussion threads 2006-09-23
- << Previous
- page 1 of 1
- Next >>
