Looking at the documentation for this phase, I was under the impression one could place code in this phase to handle errors that occur during the last batch insert. To quote SQL Books Online: "You can call this data pump phase on success or failure of a batch or rows, as defined by the value s...more >>

I recently moved a database from one server to another and uses DTS to import the data. I now get the following error on one of the pages of the website using the database. Microsoft OLE DB Provider for ODBC Drivers error '80040e14' [Microsoft][ODBC SQL Server Driver][SQL Server]Cann...more >>

Hi all, are there any known problems to install the client tools Enterprise manger, query analyzer under windows me ? minimum affords ? As i tried today, the system get`s frozen. starpower...more >>

Hi all, when i start a DTS-Packet (it`s a combination of 8 DTS- Packages, running each after each) by task, it won`t be running correctly the single packages. When i start it manually, everthing is perfekt. I`m running SQL Server 2000 standart with NT4. starpower...more >>

Hi, I am trying to create a text file in DTS using a transform data task. The source data is a sql table. I found that when the total header column width of the source table is greater than 235 characters enterprise manager locks up when trying to map the data columns. I am using...more >>

I am importing text files into SQl using the Transform Data Task. I need to validate some information by checking if a value in the text file (i.e. EmpID) exists in an existing table (Emp). I am trying to use a lookup in the Transform Data Task (Lookups tab). What I can't figure out is how do I...more >>

Hi all, I'm currently implementing a Data Warehouse in SQL Server 2000, but being quite new to the more advanced features of DTS, am struggling to create packages to support Slowly Changing Dimensions. Three of my dimensions are hybrid type 1 and type 2 SCDs, so I need to i) check the incomin...more >>

My apologies if this posts twice. We are wondering if SQL Server's DTS can easily convert packed EBCIDIC (SP.) fields to unpacked ASCII fields. If so, how do I do this (process)? Thanks, Wil William Boyd GE Retail Sales Finance william.t.boyd@ge.com...more >>

I am trying to accomplish the following: I need to clear a XLS spreadsheet on a Network Server from a DTS package. I originally was using a call to a Macro that was attached to the spreadsheet. When I run this from my PC it works fine. When I schedule it it dies. I have found several ...more >>

Im really stuck on this and its a major part of the entire DTS. I have a task ( acticex dll written in vb6), which is registered using the register custom tasks option in the DTS Designer I have three String ( varchar ) properties for this task ( name, infile & outfile ), which i can manually ins...more >>

I want to create rows in multiple tables from a single row. The source table is called "SITE" and the fields are as follows: (very simplified) ID numeric Name string Address1 string Address2 string Address3 string The destination will have two separate tables. SITES a...more >>

Hi, I'm using DTS to upload a text file to a sql server database. I'm trying to perform a subtraction calculation between two of the source fields and put that in a destination field. I've done this successfully before but in this case the source fields have currency ('$') signs and I nee...more >>

Hi All How would I go about capturing the outut that is displayed on the Execution progress form that is displayed when a DTS Package is executed interactivley. I would like to capture the details that are shown including the step that is running and the number of records processed as ...more >>

OK - I have managed to get my user the ability to execute the DTS package. However, in order to do this, she apparently needs to have Admin priviledges on the server?? This does not seem right. Could this be because a group priviledge issue? I created the DTS package and I have admin p...more >>

I am trying to insert multiple rows in a target table using a single row from a source. I read most of the posts on the subject but cannot make it work. Here is what I did so far: 1) Create a Data Driven Query Task 2) I define the following properties 3) Source tab: I define my select stat...more >>

We have a DTS package that uses a DDQ to send email and update a table. The package is updating the same table that it is selecting from, therefore the source table and the binding table are the same. Also, the update query is calling a stored procedure to send the email and update the table. Oc...more >>

We tried exporting the data (sqlsvr7) to a flat file and using sqlldr. Not working. The dts package will connect to the table in oracle but there is over 8Gb of data and we want to speed this up. Is there a method to export the binary data to a flatfile that preserves the binary format such that ...more >>

Hi all, I have some DTS packages that are used to import /export data to a SQL box located outside in a DMZ behind a firewall. We need to open up a port in the firewall so that the Internal Server can communicate (Execute DTS packages against) with the SQL box located outside the DMZ. How d...more >>

I'm using the following code in an ActiveX Script Task to write to the package log for a DTS package Function Main( DTSPackageLog.WriteStringToLog "Hey, what's this? Main = DTSTaskExecResult_Succes End Functio When I look at the log after execution, my message shows up in the Task Detail, b...more >>

Hi, I've got a DTS package with a number of Data Transformation tasks pulling data from an Oracle database into a SQL Server 7 database. I'm not doing any conversion of the data - it's a straight per column copy. When I run the package from my local machine (which has SQL Server 2000 client...more >>

I'm using SS2000. Is it possible to send a message to a cell phone if a package fails? Thanks, Dan ...more >>

Hi All , I have an issue when transferring the data from ORACLE 8i to SQL Server 2000. The are no network issue for both Database , my SQL server already apply the service pack 3.The configuration of oracle is fine. But when I create a DTS package and drag the oracle connection ...more >>

I have an Active X Script defined for a DTS... During the execution of this script, I want to execute some other DTS as a part of the execution. Is there any command to run some other existing DTS this way ? I need some help......more >>

I've recently created a replica of our production datawarehouse on our new development server. All databases, DTS packages and agent jobs are identical. Production runs perfectly however on development I'm experiencing an interesting phenomenon which is causing some headaches SOME - not all - of...more >>

Hi All, I have been asked to move a DTS package between servers and to remove the package password. I know the password and can edit the package on the new server, but can't see an option anywhere to change or remove the password. DOH! I confessed my inexperience with DTS and asked a colleague...more >>

I had put out a question earlier today that may need to be re-asked. Can the osql be used in DTS? I have to create a bunch of files, that will need the same date & time stamp glommed onto the first part of the row. I do this by putting the following code in the SQL I have in the transform...more >>

I suspect that I am running into an NT authentication issue here and I have no clue what to do about it. I have a DTS package that selects data from a SQL Server database and imports it into Oracle. I can run the package just fine. My backup developer can run the package from her machin...more >>

I need to migrate a PostgreSQL database to MS SQL Server 2000, but I'm coming up short on information on the best way to do this. Google hasn't found any good information. Can anyone make recommendations on this, or point me to web pages that discuss this? Thanks for your help....more >>

I have a DTS Package using ActiveX Transform - have a column GL_ACCOUNT is varchar 10. Goal is to tranform to first xx-xxx-xxxx. The LEFT and the RIGHT string functions work fine. Am getting type mismatch error when using SUBSTRING - any ideas why? Any help would be greatly appreciated!! ...more >>

Is there a way to change the step name in a package that is logged in sysdtssteplog table? I would like to replace the generic names with something more descriptive. Thanks, Curt...more >>

Recently (within the last 2 months) we began having a problem using DTS for conversion of DBFs that have a Logical field. The field, which is logical in Clipper, is never null in the DBF when viewed from DBX, but the results from DTS are definitely incorrect. (We verified through DBX that ...more >>

Hello I have a text file with comma as column delimiter and CR+LF as RowDelimiter, from which I am transfering data to SQL server 2000 table. In that file, 2 columns does not have values. In the DTS Designer properties, I checked 'Allow Nulls' property. But still I am getting error as follows ...more >>

Hi Darren Sorry i confused you with the word user, i should have used DBA,we are 3 of us who can access production database and we login with different id's ,i want to restrict our permissions on production database.we must be able to read the data from production but not delete or write to produc...more >>

Hello all, I have a user who is experiencing a very unusual problem with the DTS Designer. When she trys to create a new DTS package, she is immediately greeted with a message box with a title called "DTS Designer Error" and the message is about 13 boxes. The only option is to click OK, a...more >>

Hi I have a code like ******************************** Dim loColumn As DTS.Colum loColumn = loTransformation.SourceColumns.New("Col001",14 loColumn.Name = "Col001 loColumn.Ordinal = loColumn.Flags = 3 loColumn.Size = 25 loColumn.DataType = 12 loColumn.Precision = loColumn.NumericScale...more >>

Hi all, I would like to set up permisions in such a way that the user can only read the database and cannot update it while running DTS.i.e the user must be able to export data but not import into production database.What settings would fulfill this scenario,i have been trying with all ...more >>

Hello, I've got Windows 2000 and SQL2000 server running Developers could not modify a DTS that other developer created long time ago. They did not have this problem before we migrated to Active Directory domain. Is there any solution for this except put all developer group to sysadmin role I al...more >>

I use dynamic properties with my .INI file for setting things like connection strings, file paths, etc. However, I'm trying to figure out how to write data back to my .INI file from a DTS package. I have a run-date key/value pair that must be updated after each successful run of the DTS packag...more >>

I am trying to build a VB.NET Application that will create DTS packages including custom tasks etc. I have previously done this in VB6.0 and it worked fine but am having trouble converting my old code to .NET 'some VB.NET code.. Imports DT Imports DTSCustTask Imports DTSPum 'some DTS stuff....more >>

I need to develop some crystal reports on some .NET ado datasets. This is easy to do if I actually had data to work with. It is much easer creating reports with you have data Therefore, I would like to run the stored procedure that the .NET ado dataset is built on and generate an XML file. I co...more >>

Hello! I'm totally newbie in DTS, I have read a lot of questions similar to mine (and their answers) but I'm not able to apply them in my own need. :-( I have a database and a template Excel. I would like to : - create a new file Excel from the template, which name would depend of the dat...more >>

Hi All, When i try to run DTS thru sp_executePkg it runs for the 1st time after that i get error. Error Source Description HelpFile HelpID ---------- --------------------------...more >>

Is there a way to easily do a middle of the string (substring) on a transformation? A copyColumn does the whole table with no changes. I am not sure how to use middle of the string type. It seems to be only used for one column or all the fields get the same changes. I am having a problem...more >>

Hi, On one of our SQL 2000 cluster servers we have been getting a lot of error messages in our SQL Server log file. Error: 66030, Severity: 15, State: 1 Occasionally it also reports Error: 66040, Severity: 15, State: 1. I have been unable to find any information on these error mes...more >>

I am setting up a connection and find that the Data Source was getting changed from Merant ODBC Driver to "Other (ODBC Data Source)". Why does it do this? If this is not normal, this may be causing me my problem. Thanks, Tom. ...more >>

I am trying to log the row transform phase to a text file while running the copycolumn type for the phase. The problem is that if you set the row transform phase filter to copycolumn - I can't find a way to write out to the text file that they are there and what row they are working on. I ...more >>

I am trying to copy a database within the same SQL Server instance, and I keep getting the message "Specified owner name 'donationstreet' either does not exist or you do not have permission to use it". The owner name does exist, and I am logged in as the sytem administrator. Any clues?...more >>

How do I write to the status line of the window from active X in the Transformation task? I am trying to print the row numbers as they are processed to someplace on the window. The status line on the window that display the progress of the package as it is progressing. Thanks, Tom. ...more >>

I have a package that import several text files. What I need to do is check for related records as I import the files. (i.e. cust# in order table exists in the customer table), if there is an error, I need to create a report and email it. I can use the lookup function (I assume) to check for th...more >>

Have writting an Access ADP that calls a SQL DTS package, works fine on my computer, but when i give it to a user. It does not find the DTS Object Library in references. So how do I installl the DTS object library on the users computer?...more >>

I have a DTS package that imports data from an Access database, and it works fine from my computer. When I try to run it from the Web, the import task fails. I'm assuming it's because the Web app cannot find the directory and file that the DTS package is looking for. Is there a way to direct the ...more >>

Hi, I have some schedules jobs with steps. The step called a DTS packge, but not appear a DTS name, DTS name's appear like that DTSRun /~Z0x14042124137D47699A85E31C3A22C8FD36B How can I know the real name ? ...more >>

Hi I have 3 tables which is dependent to one another. I want to transfer these data to another tables in a different db. I have designed the package in a way that all the data transformation tasks runs sequentially (one after another). In i am executing the step individually it works fine. bu...more >>

Hi All When I execute a DTS Package interactively I can view the Status of each step through the Execution Progress screen that contains the execution progress status bar. ie. Step 1 - Complete; Step 2 - Not Run; Step 3 - Error Occurred etc. When I click on a step that has failed I re...more >>

Hello I have turned off all 'fail on task' steps. I have turned off fail 'package on first error' on the parent package. I have turned on fail package on first error on the child package. I have also tried a number of combinations. in the child and parent packages The child packages call stored pr...more >>

Does anyone know of a way to truncate a DBF file in DTS (SQL 2K)? I have a dbf file that needs to be emptied before I can put info into it....more >>

I'm using SS2000 SP3. I have a dts package that runs fine when directly executed. However, when I schedule it, I get errors. When scheduled, it will fail on the first step which is to download a file from the ftp server. I've tried two different ways to download the file. When I try to use an ...more >>

is it possible to start a vb executable from a dts package? tia, dk...more >>

HI I am trying to run a job that contains one cmdexec step. This step contains the following c:\file.ba The bat calls the following call file.vb This job fails. I can run a simple ping command no problem but the above commands fail. Any insight is appreciated. I assume I must be calli...more >>

I have scheduled jobs that execute DTSs with duration:"no end date". However, one week ago they all stopped running and they don't run daily as scheduled at all. I have tried rescheduling but it doesn't work. Can you help? Thanks....more >>

Hi, I'm upgrading an Access 97 system to SQL Server 2000 and am encountering a few problems. Initially I tried using the tool from microsoft in Access, but I kept getting overflow errors. Instead I thought I'd use the DTS instead. I've established a connection to my access mdb and to the...more >>

hello, I'd like to use a global variable in the source sql-query of a data driven query task. I simply use a ? for the parameter. My database connection is a Microsoft OLE DB provider for sql-server. The problem is that he doesn't accept this syntax, he gives a syntax-error and when I remo...more >>

IS it possible to run a DTS command through query analyzer so that data is picked up from mysql on Linux platform and transferred to MS SQL enterprise edition on win 2000 server platform. If there are alternate means suggest. I do not have admin rights on the linux platform and can retriev...more >>

I have created a Custom Task using VB6 I've registered the task in the DTS as 'FileReader' and has two parameters 'ExistingFileName' and 'NewFileName how do i set the two parameters for this task from an activex task ??...more >>

Developers are trying to co-develope DTS packages, but we've not been able to determine how more than one individual can modify the code. We've added the owner password, but it only allows the owner to save it, and all others just to open it in design mode Any input would be appreciated Thanks...more >>

Hi, Via a DTS, I am bringing in data from my OLTP system into my Staging area. The problem is that since I am not aware of any alternative solution therefore I am currently bringing ALL the to-date records from my SALES table (from my OLTP system) into one of the tables in the Staging a...more >>

What rights does one need to create a dts package, and what rights to see the packages and execute one TIA Fred...more >>

Hi I need to create a table and use it in a package. However, this package may be called simultaneously by several users. Can anyone tell me the standard way of doing this? I have played around with temporary tables but separate execute sql steps don't seem to recognise them. Can I use global temp ...more >>

hi all !!! I have a DTS package that it is failing with a "timeout expired" message when reading from SQL Server. I suspect about locking problems when some data combination happens, because the same package runs fine for most of the data sets I run it with, but with some ones fails. So ...more >>

Hi I have used dts from my pc from a location in london to copy data using dts from a sql server in America to a sql server in Scotland the data is about 50mb will this cause any traffic on my London link if so would you know roughly how much. Each office has its own link to each location ...more >>