I am writing a DTS package in SQL 2000 SP1 running Advanced Server SP2. I am trying to output the results from a sql query to a csv file. When I preview the results of the sql statement from inside the 'tranform data task' window all looks fine, but when the package is executed one […]
2001-08-29
2 reads
The company I work for has recently decided to use Source Safe on all of our DTS packages. To do this we save the package down as a .dts file and check it into SS. We've ran into a bump in the road though. When saving as a .dts file, we lose all of the […]
2001-08-27
3 reads
I have two triggers on a table, one for ON INSERT and one for ON UPDATE. The two triggers are designed to add a line of history to a field when certain operations are peformed. ON INSERT adds a line "created on etc etc" and the UPDATE checks via IF UPDATE() on a single column […]
2001-08-22
112 reads
In our datacenter environment, we are looking for a database monitoring software with which it would be possible to monitor different RDBMSs (presently we support clients with MS SQL Server, ORACLE, and DB2) and multiple instances on multiple servers, with reporting possibilites, threshold monitoring and alert generation possibilities. I've looked at Embarcadero's DBArtisan and Performance […]
2001-08-16
Comments posted to this topic are about the content posted at http://qa.sqlservercentral.com/columnists/sjones/analternativetowindowsnt.asp
2001-08-16
1 reads
When a server running sql 7.0 tries to get information from the sysindexes table of another server running sql 2000 ,following error occurs : OLE DB provider 'SQLOLEDB' supplied inconsistent metadata for a column. Metadata information was changed at execution time. The query i am running is : select rows FROM [serverRunningsql2000].[dbname].dbo.sysindexes where indid < […]
2001-08-07
41 reads
Something that look simple enough not to cause any nightmare is drawing me through hell. I have a third party monitoring utilities that goes through my errorlog and NT eventlog for any error and generate a ticket when any error that has severity 19 and above. I created a user error message 5001 and 5002 […]
2001-08-02
5 reads
Hi all, I am using an Execute SQL task in DTS to assign a value to a global variable. Then I use the global variable in a Transform Data task that transfers rows from an Oracle table to a SQL Server 2000 table. I am unable to refer to the global variable at all in […]
2001-08-01
5 reads
I've recently had my machine rebuilt and reinstalled SQL 2000 and SP1. When I go into existing DTS packages I get a message DTS Designer Error |||||| and the task selection area is blank. Also only register and unregister custom tasks are available from the menu line. Any ideas?
2001-07-31
6 reads
I am about to schedule the above exam and was thinking of buying the corresponding Transcender to help me prepare. Has anyone gone along a similar route, because I need to know if it is worth buying - how closely does the Transcensder map to the exam? Regards, Paul
2001-07-23
6 reads
By Steve Jones
I can’t remember how I heard about Small Data SF 2024, but it caught...
By Steve Jones
moledro – n. a feeling of resonant connection with an author or artist you’ll...
By Arun Sirpal
Let’s go back to data platforms today and I want to talk about a...
Comments posted to this topic are about the item 7 sept, scheduled book
Comments posted to this topic are about the item 7 sept, schedlued article
Comments posted to this topic are about the item 6 sept, published book
Azure Data Lake Storage Gen 2 is built on ...?
See possible answers