Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- DTS ActiveX calling Excel Macro
- I have a DTS package ,which used ActiveX to call Excel application macro to update a few worksheets.Each time it execute in the SQL Server Agent, it seem to go on forever. Usually takes around 5 to 7 mins. But, if I execute manually sometime it completed successfully and recently...
- Tags: DTS, DTS ActiveX, hardware, kaypaul@..., MAKE SURE, Microsoft Excel
- Q&A 2005-08-10
- DTS ActiveX Script
- I have a DTS ActiveX Script, which I open a excel spreadsheet to Update. It was running fine all the while, until the last 2 days. It ran for over an hours and still not finished. This package usually runs for around 6 to 7 mins the max.I enclose the...
- Tags: DTS, DTS ActiveX, DTS ActiveX Script, ExcelObject.Workbooks, kaypaul@..., software
- Q&A 2005-01-11
Additional Resources
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- State Agency Upgrades Operating System to Support Consolidation and Virtualization
- The State of California relies on technology to run all facets of government. Department of Technology Services DTS wanted to encourage a shared services model in order to provide a higher level of service to customer agencies and decrease overall costs. In late 2007, DTS decided to upgrade its data...
- Tags: Virtualization, Agency, Operating System, Consolidation, Server Computer, Microsoft Windows, Productivity, Data Centers, Microsoft Windows Server 2008, Servers, Advertising & Promotion, Operating Systems, Software, Storage, Hardware, Data Management, Marketing
- Case studies 2008-04-01
- 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
- << Previous
- page 1 of 1
- Next >>
