Hi, I've a strange behavior on my server. I've a lot of packages to execute. (I've 1 big package which execute all other packages, near 80 to execute) A day all works fine, and the next execution the same package on the same data takes 10 more times ! Normally in 1hour all is done. actu...more >>

I've got a .csv file named proddata.txt that I'd like to import into a SQL server table entitled production. I'm confused as to how to do this. Is there some information somewhere that would explain how to set up the datasource and do the import, etc? Thanks in advance....more >>

Hello, I am new to DTS. If I want to use the "Send Email Task", it requires the "MAPI". May I know where I can download the "MAPI"? Thanks a lot. Sa ...more >>

I've seen this question around the newsgroups so I thought that I would post my soltuion to it. The undocumented stored procedure sp_reassign_dtspackageowner works fine if you are in the System Administrator server role but it's not very good for allowing, say, developers to change the owner of ...more >>

Hi, I installed a SQL SERVER Evaluation version at home and I have a Comast Cabel Internet Connection. and for sure, I have a email account in my MS Outlook. However, I am not able to use xp_sendmail command? Am i missing something? Thanks Ed...more >>

Hi, I have to import a data file into my table. My table has 4 columns & the datafile has 3 columns. I am using the following format file with fixed length. 7.0 3 1 SQLCHAR 0 5 "" 1 order_number 2 SQLCHAR 0 7 "" 2 item_number 3 SQLCHAR 0 15 "" 3 type 4 SQLCHAR 0 0 "\r\n" 0 info_...more >>

Hi I am using two servers with sql 2000 I have being trying to dts a read only database into a another database with the recreate all objects.I have being able to copy other databases but this one keeps failing. Do you know if there is a problem using DTS on a read only DB. Thanks for any...more >>

Hi, I need to move a access 97 database to sql server 2000. What is the best way to achieve this? Is there any upsizing wizard for the above verisons. Thanks ...more >>

Hi,everybody! I want to transmit the source data of SQL SERVER 2000 to other SQL SERVER 2000 database server by Data Driven Query Task every 10 minutes. Because the source data will be modified by data-collector at any moment, i want to use Data Driven Query Task function to transfer the change...more >>

Hi i want to move a set of tables into sqlserver2k to oracle is it possible to using DTS package? but i want to using dts thro a stored procedure how could i use dts package in stored procedure? tell me Regards Rowthri ***************************************** * This message was poste...more >>

I have a cube which as some data and now I need to modify the data in the cube based on some business rules and write the data back. Can you please give me ideas what is the best way I can do it through a DTS package. Thanks Karen...more >>

Hi all, I'm not very familiar with SQL Server but I have a task I would like to implement. I am not sure if it is possible but any feedback would be good. I have a stored procedure which runs a simple query. I want to export the results of this query to a text/csv file as a job. The fre...more >>

I HAVE QUERY AS FOLLOW SELECT NAME+COST+ID FROM CUSTOMERS I am trying to design a package that will exort this info into a text file. But when I try to degin the package I get an error. "To Continue, define tranformations. You can make changes to the default transformations" Why do...more >>

hi, I would like to know if DTS is a good way to open EXCEL workbooks in a folder and refresh the workbooks (VBA code in WOrkbook to extract data from a SQL Server database) by running a macro. I need to do this because I need to schedule this refresh task on a weekly,monthly basis? I would ...more >>

The client I'm working at right now is currently moving from their current ERP contained on AS/400 to a MS SQL Server based ERP known as SYSPRO. In doing so they are migrating 2 physical AS/400's with 4 business units (2 on each 400) over to SYSPRO. They have moved one out of the four and a ...more >>

"Test" button inside DTS designer on any transformation is not appearing. I have Sql Server 2000 server installed in my system, running on Windows 2000 professional. Can anyone help me out to get "Test" button please. Thank you....more >>

Hi all I have to update an SQL Server DB Table with data from an iSeries DB Table with the same structure. I would like to import data everyday and i would like to update only the changed rows. Is there a way to do this? or is it only possible to update evertime all rows? thanks for ...more >>

I have been given the task of trying to correct some issues with some legacy code and I have a question. Is it possible to disable a task using SQL. For example, I have task A, B and C. Step A truncates a table, Step B checks to see if the table is loadable (from a control table). If the table...more >>

I am having a problem scheduling a DTS package. I can successfully execute the package from within Enterprise Manager or using the DTSrunui utility. I have tried right clicking on the package in Enterprise Manger to schedule the job. I have used the DTSrunui utility to schedule the job. An...more >>

Ok all: Quick performance questions... I have a client who does a lot of their email reporting out of SQL Server DTS(...yes I know, why not SRS...) They are building ADO recordsets in the ActiveX tasks. Would it be more efficient to use the SQL task to run the query and assign it to a ...more >>

Hi Everyone im using an active script to execute a query and loop to get the id for each row that return from the query 1- is it it possible in active x script to customize & send email during the loop??????? & if it isnt possible how to make the mail task to be send with the number of loop ...more >>

I'm attempting to execute several DELETE statements via an ExecuteSQL task. I need to access a global variable that's set earlier in the package. I've gotten this to work for simpler queries, but for this particular set of SQL statements, I'm getting the following errors: Error Source: Mic...more >>

I am having a problem scheduling a DTS package. I can successfully execute the package from within Enterprise Manager or using the DTSrunui utility. I have tried right clicking on the package in Enterprise Manger to schedule the job. I have used the DTSrunui utility to schedule the job. An...more >>

I'm having trouble getting a DTS package to run on a schedule. It's a job running a single DTS package. The package drops a table, recreates it, and loads data from a flat file. I can manually execute the package. But if I try to scheudle it, the job gets the following error: Executed...more >>

Good morning. I have a package in which I have three text files with three matching Transformation Tasks into my SQL Server database. My problem is that I may need to execute one transformation on a text file, then execute that same transformation on another text file, and skip the other t...more >>

hi, i'm accessing a dts-package via vb and try to read out the datatype of a global variable (type-property of the properties-collection of the global variable-object). nonetheless, i get everytime 8 as outcome no matter if the datatype is integer, string or datetime. has anyone got a hi...more >>

Hi, I have a foxpro database files created and used by the third party vendor application. Now I want to put some sort of replication between my SQL server and the foxpro. So that my application can use this data from the sql server. I need to update only sql server tables with the foxpro tables ...more >>

I have the following incoming data file with the following structure: Material Year Month Stock on Hand ------------------------------------------------------------------------------- 000000000103063768 2004 03 2.0 000000000103063768 2004 ...more >>

Hi, this is a problem I have some longer period, so I will rephrase my question. I have done lots of testing, learnt some things but still do not have a solution for my problem. Here it is: MS SQL server 2000 I have created DTS package to copy from MS Access 2000 database to SQL table...more >>

I have several dts packages that import data into the same table. I want to add a 'type' flag to my import table, then in each of my dts packages somehow populate the 'type' column during the transformation. I don't see a way of populating a field in my table unless I choose a column from my...more >>

I want to trigger the start of another DTS package at the completion of the current DTS package run. How can I use an event to triigger one DTS package from another please note I do not want to embed the package to be triggered in the triggering package as the run of the first package will not...more >>

Greetings. I have a DTS Package that has the sole purpose of grabbing a set data from an Oracle database and putting that set into a table within a SQL Server db. The package contains two connections (obviously), and one data pump task with a very straightforward SELECT statement (no JOINs, n...more >>

Due to circumstances out with my control we have an application which writes data to an access database by dropping the table and rewriting it. I need to create a DTS which would check to see if the Access db tables exists and if it does I would like to replace the current data in a SQL server t...more >>

I've got some logic (vbs) that changes the constrainst of a step so that I can branch from a prior step and bring the two branches back together. I can't find any documentation for the value 'complete', only for success and fail. Anyone know what the value is? thanks bill page ...more >>

I am using asp.net and sql 2000. In my program I am doing a lot of data manipulations and before I do this I would like to copy my table to another table, just in case I need to put the data back to its original state. I would like to do this in the asp.net program. Can anyone help? Thank...more >>

Dear Custom DTS Task Writers: If you have written a Custom DTS Task in .Net, please attempt to modify your custom task within an ActiveX script. To do so, add your Custom DTS Task to a new package, add an ActiveX Script Task, and set its code to similar to below: Dim oPackage Dim oCusto...more >>

Hello, Quick question. I have a dts package that has a Execute Process Task step in the workflow that call a batch job (win32 process). Sometimes this step completes successfully and sometimes it does not. The return code is set to the default value of 0. When it fails, the error messa...more >>

Wir müssen Datena us einer MySQL übernehmen. Wir wollen dafür einen MySQL - Oledb Treiner aus dem Jahr 2001 nutzen. MYOleDB 3.0. Weiss jemand ob der Treiber zuverlässig arbeitet. Ich hoffe es mal oder gibt es Alternativen dazu ? Uwe ...more >>

When I try to create a new local package under dts, I receive a box that says DTS Designer Error, with a bunch of black lines in the message box. When I click OK, the connection icons dispay, but the icons under task are missing. Has anyone seen this and how do I fix it? Please help.... ...more >>

Normally this would be last night but what if you want it to be more often....have someone tried this - and if so - how ? a) real time olap b) be sure to filter records so only new records is being pullled out .. and scheduling this package more often than once a day .... how often ? per hour ...more >>

I am a DTS newbie. I created a DTS package in which i import a MS Excel file. the first time the package runs properly. After 2 days i executed the same package. It gave me two errors 1. Create table (error: the table already exists) 2 Copy data (error: no value given for one or more required...more >>

Hi.. We have somo DTS on Server, but usually users need to run DTS for can retrive data from other source, this step is very slow and server lost performance.. How can i increase server performance??.. May be if i run DTS on Other Server can be helfull?? The Data Pump run in the server...more >>

Hi, I am new to DTS and having some problem transferring Data from one server to another using stored proc in DTS. Stored proc takes around 11 parameters and does bunch of update statements and in the end it has select statement. The data return by this stored proc need to be transfered to a...more >>

How do I go about restoring the DTS package from a backup copy of the database from a month ago??...more >>

Hi, I have a problem with one of our SQL Servers. I was loading a text file (w/DTS) that has 7903 records. Exactly half way through it stops without warning and no indication that anything went wrong. The resulting table always has either 3952 or 7903 records. I've done this several times...more >>

Hello Everyone i have an ActiveX Script that returns with a global variable then in the workflow i have an sql task that insert this global variable in a table so i write in the sql task : insert into Table values (DTSGlobalVariables("id").value) It gives me an error "Incorrect Syntax Near DTSG...more >>

Hi, If there a method to format the bcp out so that it handles both commas and double quotes? To explain: I have the same problem with dts that I have with bcp. When I try to import descriptions that contain either double quotes or commas, I receive a SQLState = 22001 Sting data, right tru...more >>

Hi, I have an ActiveX script as the following: As you can see, it is calling another 14 DTS packages and How am I pass the two GlobalVariables (gMonth and gYear) into those 14 DTS packages??? Thanks a lot Ed Function Main() const DTSSQLStgFlag_UseTrustedConnection = 256 Dim myNum, g...more >>

I'm uploading data from staging tables on an as400 to staging tables on MSSQL. I want to set a status field in the source record to show whether the upload was successful or not. I think the multiphase data pump is the way to go, but I don't want to keep opening connections to the as400 wit...more >>

hi, i'm accessing a dts-package via vb and try to read out the datatype of a global variable (type-property of the properties-collection of the global variable-object). nontheless, i get everytime 8 as outcome no matter if the datatype is integer, string or datetime. has anyone got a hin...more >>