I got a problem to call my dts inside vb code. I can run my dts successfully in sql server enterprise manager or in the command line. but when I try to call it through stored prcedure, it fail and I even can't catch the error. my stored prcedure is like: CREATE PROCEDURE [dbo].[CSCDDTSRe...more >>

I have a large text file which has columns name in first row (column separated by "|" char). The file contains 125,000 records when I use DTS to import this file the DTS hangs after importing 61000 rows (as per progress bar showing). Is there is any limitation on maximum number of rows the "t...more >>

I need to backup a database on another server. And, unfortunately, I don't have permission to write to the hard drive on that server. The only way I can think to do it is table by table, using DTS. I would need to keep the DDL and sync and then for each table, truncate the destination and...more >>

I have a DTS package that basically does the following: 1) Truncates a table called MYDB.tblParameters 2) Reads a CSV file called tblParameters.csv under the C:\DEV\MyApp directory 3) Writes CSV information to SQL Server 2000 to database MYDB.tblParameters using a specific username/pass...more >>

Created a DTS package and executed it successfully from a VB .Net program via the DTS Package Object. I then added a third party custom task to the package via the DTS designer. I can still run the package successfully from Enterprise Manager or DTSRun. However, running it in the VB .Net pr...more >>

Hello all, Sorry for the length of the post but I want to be thorough and not waste anyones time suggesting something I've already tried. I have an application that pulls data from an oracle (8i) db into SQL Server for processing. At the moment it copies all of the data from the oracle tab...more >>

Hi, I am getting frastrated by trying to call DTSrun inside the stored prcedure. I want to my DTS triggered by user interface clicking. So I wrote a stored procedure inside sql server and call DTS inside the stored procedure: CREATE PROCEDURE [dbo].[CSCDDTSRefresh] AS EXEC master..xp_cmdS...more >>

I have a DTS package scheduled to export data to a text file daily. Sometimes, on two consecutive days, the data exported are the same when the job runs as scheduled. If I run the job manually using the same parameters (date/time), the data are different. There is no particular pattern to it. ...more >>

Hi I have written a dts in SQL Server which uses the Send Mail task. I would like to log the details of a failure, if the mail fails to be delivered, ie if the email address is invalid. The problem is that the Workflow On Failure event will only fire if the mail fails to be sent, not if ...more >>

I am in the process of consolidating 17 SQL servers into 3 (yes they extremely under-utilized). I am trying to use the Copy Database Wizard to do this, mostly because there are a couple hundred databases that need to be moved and it would be very tedious to do each one via backup and restore ...more >>

When I set the destination column, SQL craches. Anybody can help me?...more >>

My DTS package was working great yesterday, so I closed Enterprise Manager and started working on "prettying" up the excel file. Not anything too drastic, just validating cells and the like. I just updated all my Excel files and ran the package. Now the DTS package is importing 499 record...more >>

Hello All, im am experiencing difficulty with automating a DTS package. if i try to run it manually it work, if i try to automate it with the scheduler it always fails. to debug it i executed it using dts run to gain more information and i got the following output below C:\Documents an...more >>

Description: We are using a DTS to build a table just for FT indexing. Basically we gather all of the words from the fields we'd like to search, and put them into a single table (moosejaw_tblFullText). Then we're using FormsOf (Inflecitonal...) to get results as the SQL below shows. For on...more >>

Hi, I have a package that starts and ends with ActiveX tasks. The first task locates a file and then enables the following step: Set stpStart = pkg.Steps("DTSStep_DTSDataPumpTask_1") stpStart.DisableStep=False stpStart.ExecutionStatus = DTSStepExecStat_Waiting The ending Active...more >>

Hi All is there a way to trace the DTS package. We use profiler to profile/trace the sql database. but is there a way to trace the dts package, each step of it. We have active x script and i need to trace thru each step as it executes. thanks in advance ...more >>

I have a number of packages that I need to move from one server to another. However, I also need to add owner and user passwords to each package. I am trying to find out if I can do this from the back end by select the records (DTS packages) and inserting them into the destination servers' sys...more >>

I have some code that I am using to import a flat file into a bunch of related tables. I am trying to make it so that new records are added to the related tables of a new value appears. However, my code thinks that every value is new and unique and creates a new entry for it. For example, o...more >>

I have a link server I'm trying to connect to in a DTS package. I'm not sure what connection to use and how to set it up. Any suggestions?? ...more >>

OK, wrote a DTS package that has multiple ActiveX steps. In an early step I create and populate a dictionary object, create a new global variable on the fly and set its value to the dict, and then fetch the value from the global in later steps and use the values. It all worked fine until ......more >>

I have a requirement to populate a table from a file whose name changes every time it is run. I can determine the file name using an ActiveX VBScript and would like to then point the Text File Connection to it. How would I do this? Or is this the best way to do this? I am learning but my ...more >>

Please help: I am trying to create a piple delimited text file through a DTS export which consists of about 93 different fields. However, there is one data field that is populated from a list of options. The user is allowed to choose one, click an add button, choose another, click add, et...more >>

Can someone please tell me how/where is the log file when I am scheduling an Export from one database to another. I would like to see the details of the success or failure of that job. Thank you. ...more >>

I'm running EM on my local box and sql server on a remote interne accessed box. How do I specify a file path for a DTS package to access files on th remote box For example, to run a local dts package the path i c:\filepath\file.txt How would I change the file name to allow the remote dts p...more >>

I have a DTS package that is used to import a flat file into my database. This file is a rotating log file that could hold information that has been imported previously so I was testing running the import multiple times when I ran into this COMExcpetion (I'm calling the DTS package from a C# app...more >>

I have to create a DTS package that will import a file into my database. This file can come from a Unix machine or a DOS machine so the row delimiter will be either {LF} or {CR}{LF}. I know I can write my package to handle either of these row delimiters, but can I write it so that it will handl...more >>

Hi, As a beginner with DTS, I'd like to know if it's possible to export data from a sqlserver with a package, but without predefined tablecolumns to export. I want to build an export module from C# that exports columns the user has selected (thus at runtime). The DTS packages I have tried to ...more >>

Ok, I am getting this project pinned down, just need some more help. My SQL Task uses a simple query, SELECT ExcelLink FROM Cardholder I would like to know if it would be possible to return 2 columns of data, SELECT CardholderID, ExcelLink FROM Cardholder and then use the ExcelLink ...more >>

Hi All, I have to create a report text file but in special format base on information from a tables data. The text file I need to create it in a particular folder with this format: Report Date 5/24/2005 Batch: 001 From position: 532 To position: 543 Descri...more >>

Hi , I am having probelm with Global Variables in my DTS Package. Data Transform Task is defiend between 2 SQL Server. I have defined Global variable in my Package and trying to pass variable value to SQL Statement defined in Data Transform Task. For Example 1) Gloabal Var : OrderNo,...more >>

I am beyond my capability in trying to move MS CRM accountbase data via the CRM Data Migration utility. My difficulty is in handling the Uniqueidentifier Primary Key "AccountId" guid from the originating table and passing that 16 character GUID to an intermediate table which has a Primary Key "...more >>

I would like to create a DTS package that will accomplish the following: Check if a database table A has records. If Yes go Else Stop. Erase Replica table B. Copy Database table A to replica table B. I'm able to copy all records from one table to another automatically. I would like some ...more >>

My individual steps all work fine. If you click on each step with the mouse the whole DTS package will run fine. If you execute the DTS package, it will run with all success messages, however some blocks of code wont run, you'll have to click on them to execute even though messages say they ex...more >>

Hi. I'm using SQL Enterprise Manager 8.0 and importing a text file into a SQL table using a DTS package. The text file has rows with 542 characters in each row and a CR LF (0D 0A) at the end of each row in position 543. Using a Hex editor (Ultra-Edit) I was able to confirm the CR LF at the...more >>

I'm importing from Text (file) into a table that consists of 83 varchar fields, then an Identity field. The source file has no ID field, just CSV data ( max 83 fields ). In the Import Wizard as soon as I specify the field delimiter ( comma ) the display shows that all unspecified ( in the in...more >>

Ok... I know this is probably a VERY dumb question, but how can I install the sample files (*.dts) into SQL Server? I searched the server for *.dts, with no results. Thanks, Drew ...more >>

I have a urgent need to use DTS for processing some EDI files to be loaded into SQL Server and also outputting data in SQL Server to EDI. Can somebody kindly share a sample EDI file and an ActiveX script you have built to process this file inbound into SQL Server I would greatly appreciate the...more >>

I am getting the following error: "Too many columns found in the current row; non-whitespace characters were found after the last defined column's data. " It seems a few people (going by google/newsgroup searches) have encountered this, but none of which had a very clear resolution. I am ...more >>

Is updating a much more demanding task than inserting ? If so would the best approach always be to construct the insert sentence with joins to as much table as possible in order to avoid updating ? Have 3 tables with a 5 mio b 11 mio c 5 mio d 0 When inserting a/b into d it only takes...more >>

Hi I've successfully executed DTS packages using Vb6, but need to do so in C#. Are there any libraries included in the .NET framework to facilitate this, or will I have to use the COM components found with SQL2000? (I'd prefer to be able to use the .NET libraries, but have been unable to fi...more >>

I understand how to loop through a RS and extract data (using Active-X controls and SQL Task), but now I need to add a data transform in there (from Excel to SQL). Here is the lowdown, The SQL Task just uses a simple query, SELECT ExcelLink FROM Cardholder This returns about 7 records...more >>

I am trying to consolidate some code that I had replicated in many places in my DTS package by placing it in a Dynamic Property that sets a global variable. I can reference this variable through ActiveX Scripts with no problem. However, I can not figure out how to access it in an SQL query i...more >>

I am working on building an app for logging credit card transactions. I made a small excel file that the users edit and the user edits the file and then the file is DTS'd into a SQL Server database. I have the following tables, CREATE TABLE [dbo].[Cardholder] ( [CardholderID] [varchar] ...more >>

Hello, Two weeks ago we migrated our database to another server including our DTS packages. We went in and replaced the Server connections with the new server name where necessary including within Active X scripts where a connection is declared. The problem is, now all of the packages I run...more >>

Anyone where I can download or purchase an OLEDB driver for Informix? Thanks!...more >>

When a SQL job has been created to run a local DTS package it fails with the following error message. The job failed. Unable to determine if the owner (DomainName\UserAccount) of job MyJobName has server access (reason: Could not obtain information about Windows NT group/user ' DomainName\Us...more >>

I have a DTS package that is scheduled to pull read-only data from an Informix server every 10 minutes. When it works, it takes less than 10 seconds. I have *zero* control over the Informix server, so all error handling *must* be done on the SQL Server side. At times, this job executes e...more >>

Hi, We have a situation here where a consultant has come in and developed approximately 45 complex DTS packages on the development server (lets say its called SERVER1DEV). Within an unknown number of the packages, there are references to SERVER1DEV. I want to make a working copy of the dat...more >>

Hi All, How I can process my cubes via DTS on my web server? My OLAP and OLTP databases is on a database server. I can run DTS package if no process cube task in my package but the task failed when process cube was added to the package. ASP.NET page return error Invalid class string. ...more >>

hi, I have a package that imports data from Informix 9.X to SQL Server 2000. I found the transformation always stop at the last DTSRun OnProgress for a long long time. Eg. there are 534330 rows in Informix DB and the transformation processes very quickly, but always stays at the last DTSRun OnP...more >>