Greetings, I have a VB6 custom task that calls another process via a custom written C++ Dll who's purpose it is to spawn and control another app by grabbing its std handles. The C++ Dll exists as an ActiveX control withinn the VB project and it all works perfectly until the task is executed b...more >>

I am trying to develop an automatic synchronization between 2 tables and run it once a day. The fields of the Source Table are : SSN, first, last, phone, email The fields of the Destination Table are : IT_ID, SSN, first, last, phone, email (the same 5 fields + a unique ID) Durin...more >>

Hello, I need some help. I've been doing a lot of reading but cannot seem to get over this error. My software: Win2000, SQL 2000, VB.Net I have a DTS package in SQL Serve that works fine. I want to use it in a VB.Net application. -1. I created a .bas file from the DTS designer. -2. I im...more >>

Hi all, I am a relative newbie to DTS and want to be able to search a group of DTS packages for a specific string which in this case if a piece of SQL. The dts file appears to be stored in some encrypted form and I cant find any search tool on the menu. Does anyone know how to do this ? Thanks ...more >>

Hope this is the right forum to post in. I am calling a DTS package from asp. On test server, it worked fine. On production server, we are getting an error on creating the object DTS.Package - server.createObject failed - invalid progID. Inable to find this exact issue in the KB or on th...more >>

I am having problems with this issue and I think it might be a bug with SQL Server 2000. If you add a user to the targetserverrole in the msdb db, it will allow him/her to see jobs and dts packages. However, on jobs that are still executing, it does not show the running status. Instead, it wil...more >>

how I can make backups for DTS?...more >>

Hi All! Is there a way in Date Time String Transformation Properties to convert the time format to 24H? I have tried all the date format but i don't see any 24H format. Please help. Thanks ...more >>

Hi, I have global variable which I change within one of the DTS package tasks (Active X). I want to store date and time of package execution in this global variable, so I can use it for next execution. The problem is that global variable doesn't remember new date/time, assigned within Acti...more >>

Hello, We've migrated from SQL 7 to SQL 2000 and it seems that some of the existing UPDATE statements aren't working correctly. -- current -- (SQL 7) update company_items_quarterly set company_id = c.company_id from company_items_quarterly cq, company c where cq.ticker = c.ticker -------...more >>

A script is showing error on server but on my developemnet site there is no error. the following is the error ADODB.Field error '800a0bcd' Either BOF or EOF is True, or the current record has been deleted. Requested operation requires a current record. thru msdn there is big explanat...more >>

I am having a peculiar problem when i am using a DSN Connection i am getting Record count but when i am using Provider=SQLOLEDB.1............. i am getting Record count -1 Anybody can show a reason for this thanks in advance...more >>

How do I read in a text file that has fixed column positions, but the last column is variable in length? Each row has the appropriate terminating CRLF....more >>

We are importing a lot of data from text files to our SQL Server tables. We use DTS's to achieve this. After many problems, and a lot of frustration, the DTS's seem to be working fine, except that now some stored procedures behave differently when executed from the DTS vs when we execute them fr...more >>

Folks Using SQL Server 2000 SP3 I'm using the GetExecutionErrorInfo in ActiveX Scripting tasks to try and get error information but the GetExecutionErrorInfo does not return any data except an error code of zero... consequently the elbaorate tracing and error handling system we have built a...more >>

I developed an ActiveX script inside of a DTS package. Now I need to install that DTS on another SqlServer which isn't on the same network where the server where is was developed (so a simple Save as... ojn the other server cannot work here). This ActiveX uses two activeX dll's which are simpl...more >>

Hi, In the Execute Package task, is there any way of preventing the Package ID from being stored so that it is determined at runtime rather than design time? I want to execute a package by name and not ID because the package ID's can change when transferring packages between servers. I g...more >>

Hi all, Thanks for your help in advance. The problem that we are having is that when we try to transform text data from Excel to a varchar in SQL Server numeric values are transformed as Null values. For example if the Excel dataset is like below the numeric values are copied as Null ...more >>

Dear all What is the FASTEST way to count the number of rows in a file. I have a comma-separated file (*.csv) that is a data export from one database and will be used as a data feed file for a DTS package. I know from some meta data that the file should contain say x million rows and I wan...more >>

I've got a package that uses some Execute SQL tasks to mark staging records and either insert or update them into production tables, based on how they're marked. Initially, there were problems with my marking queries, and I ended up trying to insert records that already existed. This should hav...more >>

I am trying to purge a database of data over 13 months old. I can easily move the old data to an archive table and the new data to a transfer table. Management wants the table dropped and recreated before transfering the data back so indexing can be recreated and any other problems remov...more >>

Hello: I am starting to accumulate a lot of DTS packages in my SQL2K database. How can I back these packages up in case of an emergency? If anyone has any suggestions or can refer me to any reference materials on the subject, I'd appreciate it. Thanks Brennan...more >>

I am using Execute SQL Task and following sp: Execute CDO_SendMail @From = 'tt@msn.com', @To = 'bb@yahoo.com, @Cc = '', @Bcc = '', @Subject = 'Test', @MessageFormat = 0, @Message = '' My questions: 1. Is it possible to attached file into email 2.I am trying to pass a parametrs inot ...more >>

I was wondering about the maximum number of tables that could be imported by one DTS package. The SEARCH seems to be inop - otherwise I wouldn't bother y'all....more >>

I have a transform data task that is pulling records from a table for prepping before inserting into another. Is there a way to stop the DTS package at that point if the transform data task does not pull any records from it's select statement. All assistance is appreciated ...more >>

Hi. I am trying to design a package and get an error when I try to define a transformation with ActiveX script for a data driven task. Environment: SQL 2000, 8.00.760 SP3 Error: Package error. Unspecified error. Data Driven Query--> Transformations-->New-->ActiveX script. Any pointers? ...more >>

I know that I have asked this question but I forgot how to do it. I have a DTS package that is going to be entering several records at a time into a table with a primary key defined. What I need to do is when I insert a record into that table, I need to be able to retrieve that id after ...more >>

Hi guys i've a problem a sql server begin the service sqlmail with profile (testing perfect), but when send my email with xp_sendmail or send an email with outlook so: Algunos de los destinatarios no recibieron su mensaje. Asunto: hi, this is a sample Enviado el: 09/07/2003 0...more >>

Is there any way, without using SQL Agent, to run dts's asyncronously? I have 12 dts's - based on regional info, depending on several factors I need to run any number of them, via a gui front-end, where a user selects which of the 'regions' to process. I don't know how to process them one ...more >>

I have several DTS packages (108) that write results sets to files every night. I am trying to consolidate the packages to use one package to fire off the rest. We will be moving our database to a datacenter, which will greatly affect the packages. The destination on the transformation is a t...more >>

Hi, I am calling an 'Execute Package Task' in my DTS package to execute another DTS package. It looks like the execution status of the inner package is NOT being carried over tot the calling package. This is what I have: Package A:- Package B - on success - Step 2 Package B - on failure ...more >>

Hi, I have 5 DTSsses that are executed by a Main DTS. All packages insert lots of data into our DB. I've noticed that our Server's transaction log reached its limit of 100 GB. We cleaned the log file and now we are back in business. What is the best practice when inserting lots of data into ...more >>

hi I am new to the DTS. I have a text file and need to be appended into a table in SQL. This is happening every month there is a key for the table. However, the text file may have the duplicates in the key field or the key is alreay existing in the table in SQL. When I try to import the ...more >>

I have several DTS packages and I have scheduled them. The Agent starts them up but never gets a complete status. I stop them manually and look at the log and the DTS package itself completes successfully. Can anyone help with this please. Thanks Alan...more >>

Hi I want to create a DTS package that does a one-off bulk import of data into a database. It needs to run this bulk import within 10 minutes of the data-files appearing in a directory; these datafiles will be generated by an "un-predictable" automated process - by that, I mean the files co...more >>

How can I default null values to parameters in an SQL Task being executed from a DTS package? The task executes a stored procedure that expects a number of parameters as shown below: CREATE PROCEDURE [CT_IMPORT_RATES] (@clause_id int, @table varchar(20), @startrg ...more >>

I have multiple DataPump Tasks that go from one connection object to another. I would like to be able to set the order of their execution (at design time) as each builds on the previos one. Is this possible? And is this possible without creating seperate connection objects for each step?...more >>

Can I use DTS to transfer a database from SQL 7 to SQL 2000? This database is compatible with either release....more >>

Hello, I need to run DTS packages saved on SQL Server via C# Web App. Is there is someone that know how I can do it? I am using an RCW around Microsoft.SQLServer.DTSPkg80 with a C# console application and this works fine. If I create a C# Web App it does nothing. Probably there are some ...more >>

Hello, I am writing a paper as part of my masters on ETL tools and I am in need of user opinions of Microsoft's DTS (pros/cons). Any input would be greatly appreciated. Thanks. Charles Woolard woolcha@iit.edu ...more >>

I have a simple DTS package that moves data from a flat file to a table. It does very little scrubbing. Here is the ActiveX code: Function Main() DTSDestination("ColA") = DTSSource("Col002") DTSDestination("ColB") = left(DTSSource("Col003"), 4) &"-" & right(DTSSource("Col003"), 2) DTSDe...more >>

I have SQL Server 7.0 Client installed, and when I try to execute a local DTS Package, I get the error message "Error occurred during creation of a DTS Package". I have reinstalled the software, and still get the same message. This worked before, and nothing has been changed, either on th...more >>

Is there anyway of programmatically outputting the results from a select query straight out to a file. I am looking for a purely programmatic way that runs automated and not through job scheduling etc. Kind Regards ...more >>

Hi I keep getting the error description of "Invalid Number of Paramters" when I try to re-open / execute my save DTS package that contains a custom task which work fine when I first start my dts package. I also get this from an example custom task which I download from Microsoft site (which...more >>

I have developed an application in VB.net which calls a dts package. it runs perfectly on the development machine. when i tried to deploy it on the end user machine, it displayed an error message mentioning that a com object was not found. for the installation, I have just include the dts dll....more >>

Hi, I have a simple dts job on sql2000. I can execute the dts job through asp.net fine using the following. Dim newpackage As dts.Package newpackage = New dts.Package() newpackage.LoadFromSQLServer("ELTHNTW04\EMS", , , DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedCon...more >>

Is there a way to start a job from DTS? I want to kick off another job (not another DTS script) at the end of my DTS script. Thanks for your help, Erik erik@klein.ca...more >>

Does anyone have problems with the following on SQL Server7... 1. Password-protect DTS packages, then discovering the same password cannot open the DTS packages again 2. Saving a DTS package on the server with creator being administrator. Then trying to open it on the client (with admi...more >>