I want to load data from oracle to SQL server using DTS and to use the select...into option so the data will not generate entries in the transaction log if I use the select...into it will not work since I need to connect to SQL server and because my source is oracle I can not use this option . ...more >>

Hi I have around 100 dbf files. I have to import the DBF files into SQL server. Now i can do the same using the wizard. It works fine. Now if i try to do the same using the DTS programming i am not able to do this. First of all i can't get the structure of these DBF files in the classes provided i...more >>

I am running SQL Server 2000 standard edition with Service pack 3A installed. When I look at the books online, it says these should be at: \Program Files\Microsoft SQL Server\80\Tools\DevTools\DTS But this is not on my system. There does not seem to be anything extra to install install fo...more >>

I am trying to load a Package from a repository, my server name has a funny name but i get this mssage....could someone give a hint where I am going wrong? Private Sub Form_Load() Dim pkg As DTS.Package pkg.LoadFromRepository "17433136281", "msdb", "sa", "", "{B3E46B63-FEE6-43C...more >>

I am trying to access a DTS package on a sql server and get this error messgae .....What could be going wrong? Private Sub Form_Load() Dim pkg As DTS.package pkg.LoadFromRepository "[17433136281[Windows 95/98]]", "msdb", "sa", "", "", "", "test", DTSReposFlag_UseTrustedConnection pkg.Write...more >>

Apologies -- Newbie Question -- I have a column full of Surnames that have been entered in Upper case. I need to change them so that the first letter is capitalised and the rest of the string is in lower case. Any Ideas ?? ...more >>

Hi. I have a flat file that has many cols. the file has to be instered into many tables(each group of cols. for a table). one group has 6 cols. each of them has to be insterted into the same table with a corresponding FK value (some ID at the beginning of the line). there is a way (putting th...more >>

Hi Friends, I want to use DTS ftp task to transfer files from my local m/c to an FTP site. Is it possible to do that. If so please help me with details. rgds Ravi...more >>

I keep getting an error with DTS and can not figure this out. All my date are valid dates...so I have no clue. Can anyone help? This is the error: Error at Destination for Row number 6052. Errors encountered so far in this task: 1. Insert error, column 9 ('DATE_OF_FTES', DBTYPE_DBTIME...more >>

Hello, I currently have a large job created in Sql Server Agent, and I would like to be able to start the job using either C# or VB.Net. I know I can start a DTS package with C# but basically this job is very large and I would like SQl to run it then send a message back when it's finished...more >>

If I cancel a DTS run while it is running another package, then I cannot run that package again from within any other package. I keep getting the message "Execution was cancelled by user." When I launch the package directly , it runs fine. Can anyone help? This is a big problem. thank...more >>

Hi Everyone, I can't believe I'm the only one who wants to bring data over from Oracle with some element of dynamicness. Nor can I believe that this problem hasn't been solved already. Here's the problem: 1. Our Data Warehouse is in MS SQL 2000 2. Some source data is in Oracle 3. Some of...more >>

Hi I am having a DTS package involving following scenario Data is to be imported in two SQL Server tables from input text files. There is one text file each for each table. These tasks are named as DDQ1 and DDQ2 respectively. The workflow is such that on completion of DDQ1, DDQ2 should get execut...more >>

I have just migrated a db from one SQL Server to another. Everything seems to work fine. All of my DTS's work perfectly on the new system, however when I schedule the JOBS to run at night, the fail. This is what it says when I pull up the View Job History: DTSRun: Loading... Error: -21472...more >>

I have a DTS package set up to copy data from one SQL2K server to another SQL2K server. I'm using the copy sqlserver objects task and have specified individual tables. The job has been running fine for a couple of months, but now it is causing blocking in the source database. I'm only seeing ...more >>

Hi, I've created a simple DTS package to export a content of a table to a .CSV file. I would like to that columns in CSV file will be named as the Column names in the SQL table. It that possible to do that and how it can be achieved? Thanks, Barak ...more >>

Help me! I try to import some data from an informix 5.0 table to Sql Server 2000 with a DTS package. I use Intersolv ODBC driver version 03.011.0021 to connect to the database. It works well, but i can't define a parameter in the sql statement. For example if a try to execute : sele...more >>

How can you specify a text qualifier for char field in a format file when outputting table data to a text file using BCP? ...more >>

Hi to all, is it possible to lunch a DTS packet via a .BAT file or a line command under windows 2000 pro? Thanks in advace. Massi ...more >>

SQL Server 7.0 SP4 Hello: I guess most of are aware that ownership between creating and executing a DTS package as opposed to scheduling the same, are different especially when you create the DTS package on a SQL Server that's not local. I have a server to which I don't have physical ...more >>

hello, i am trying to do the following: i have a folder full of text files. each text file contains a list of records. each record represents one day of price/volume data for a stock (date, open, high, low, close, up volume, down volume). each text file is a set of records for one ...more >>

Hello, An application .Net has to run a DTS package. This DTS package uses a step as followed: Execute SQL Task : execute a stored procedure with parameters. The problem is that the parameters of the stored procedure are using global variables, and .Net encounters some problems with th...more >>

I am having trouble running the FTP. When diagnosed, the problem relates to issuing the "ls" command at remote server, eg. nothing happens after the "ls" command, so the FTP job hangs. Any idea how it can be rectified? ...more >>

When trying to create a DTS package using ActiveX, I get the message: ActiveX Scripting was not able to initialize the script exectution engine. My laptop is set up the same as other PC's/servers (Windows 2000 advanced server) but obviously something is missing or some service is not acti...more >>

Using Microsoft Sql 7.0 where are DTS jobs stored ?We currently keep 80-100 dts jobs on the server and I am planning my backup procedures. My SQL person tell me that they are not stored any where in the database ? Is this true? If my server failed and I restored my databases Master, mod...more >>

Any ideas on the following error message, DTS package owner is myself and I am a local Admin. Job ruuning is under my domain account. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSStep_DTSDataPumpTask_1, Error = -2147217887 ...more >>

Hi, I create a customtask in VB and when I try to change a property from a ActiveXScript Task in my DTS Package I keep receiving the following error: Step Error Source: Microsoft Data Transformation Services (DTS) Package Step Error Description:Unspecified error Step...more >>

In short, I'm trying to get the servername, databasename, userID and role from every SQL Server 2000, and load this information into one table on one server, that I'll reference as the MAINSVR. Currently this is working with the script below, but I have a DTS package & job, along with a link to...more >>

Hi All, I'm attempting to push data into an Oracle database by calling a parameterised stored procedure, (hopefully contained within a package) with data returned from a "Get" stored procedure in a SQL Server database. I planned to do this using a data-driven query task where the source was (f...more >>

Hello, I am new to dts and have the following problem. I have to import a file of the following format: head 1 <TAB> val1 head 2 <TAB> val2 head 3 <TAB> val3 .... etc... 1. <TAB> val <TAB> val <TAB> val <tab> val 2. <TAB> val <TAB> val <TAB> val <tab> val 3. <TAB> val <TAB> val <TAB> v...more >>

I am using the SQL Server 7. I have a task with multiple precedence constraints. DTS assumes a logical AND, is there any way to change this to an OR? Any help would be appreciated as I would hate to have to duplicate tasks to get around the problem Regards Chris...more >>

Hi, I'm importing Excel file into SQL sever. At the Column Mappign and Transformation screen, I see that the Destination Field Name didn't follow the Excel Column Names at all. Also the data type is nvarchar and size is 255 despite Excel column width being changed to less than 255. ...more >>

Hi everybody I have a package with a lot of task in a chain. Every task is connected with a workflow arrow. Despite that, some tasks later in the chain starts to execute before earlier tasks is completed. Why is that? Could it be because some tasks is created later and added later in package, allt...more >>

I've created a simple FTP task and I'm noticing that it doesn't report that it has failed even when I know it couldn't have run properly. In particular, it reports success even though the file I'm telling it to retrieve doesn't exist on the target machine. Is this a known error? If so, ...more >>

Hi All I've the following task Need to copy data from ServerA and from 5 tables t another ServerB at regular intervals or on demand. W need to transfer based on some condition Both are SQL Servers The data collected from ServerA has to go to different tables in ServerB There a...more >>

I have an excel spread sheet that gets edited every day. THis spreadsheet contains our employee information. I need to take that spread sheet and DTS it up to a table in my MSDE database. This needs to be done every day. I created the DTS using the wizard and all my data seems to be ...more >>

Hi guys, I'm looking for a task which can export (upload) datas into a ftp server. In Fact, I'm trying to build some automatic backups in my SQL Agent : 1. Backups my databases 2. Compress files with Winrar (command lines) 3. Transsferring compressed files to another server with...more >>

I'm very new to DTS. I've been asked to help develop DTS packages which will run on systems on the other side of the continent. The client has sent samples of work done so far. He is using local servers, and local on-disk text files in various tasks. I have brought those up here, but of course ...more >>

Hi all, Any ideas in how to run sql-statment in a dts? The output need to be sent to a file. TIA...more >>

I am getting a 'denied' select on a table but the user has appropiate permissions. I can log in as the user and execute the sql, but through the DTS Package run via DTSRUN I get permission denied. When I log on as this user via SQLEM, it works fine as well .. any ideas ? ...more >>

Does anybody familiar with the message "SQLServerAgent Security context does not have server-autorestart privilege." and " password verification of the 'SQLAgentCmd Exec' proxy account failed(reason: A required privilege is not held by the client). When I run the jobs(DTS, maintenance), I ...more >>

using DTSRUN to execute a package, had some truncate table statements in an sql steps. Truncate reserved for dbo use. The user executing the package is not the dbo nor alias, so it should fail. But in once specific recreatable instance, is does not fail. If I run the package from my machine, e...more >>

I have several DTS jobs that run off of SQL2K. For some reason the jobs seem to fail once or twice during the day at different time intervals. Here is the job History failure log: Executed as user: Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSE...more >>

I have a DTS package that is scheduled to run on the 2nd of each month. The main package runs several other packages to FTP, import, and transform data into SQL Server. This process has run successfully for 3 months until now. The scheduled job's history shows the job failed immediately on executi...more >>

Hi All, SQL Server 7 We have scheduled DTS jobs to run at specific intervals. These DTS jobs runs fine sometimes and sometimes some DTS jobs won't. When we look at the status of these jobs from Enterprise manager, we find either a) DTS job is failed or b) DTS job status shows execu...more >>

Hello, I keep getting this error and I need to know how to fix this. There are computers that can run the DTS package and others that get the following error message: The ORACLE client and networking components were not found. These components are supplied by the ORACLE Corporation and...more >>

I have a problem with creating a DTS package, SQL 2K. At first, transform data to file generates memory error. Therefore, I found an article KB814113 and microsoft's explanation that is a bug of SP3. I couldn't found a hot fix, and made a fresh installation of SQL server, without SP3. Now, maki...more >>

when i am trying to import the data from from paradox *.DB file to sql server 2000 which windows 2000 enviroment the i an getting the following error Error Source : Microsoft JET Database engine Error Description : External table is not in the expected format context : Error Calling Open...more >>

I have a package utilizing 2 'connections' but 45+ transformations. I need for the 'source' and 'destinations' to be flexible, dynamic. Changing the connections alone does not do the trick, I must go re-do each and every mapping. I'm not a vb guru and can't figure out exactly how to use a genera...more >>

Hi, We have an Access97 database, that lives on a file server running NT40SP6a, and not running SQL. We are trying to build a DTS package on an NT40SP6a/SQL7SP4 server that will open the Access database and populate a SQL database from it. Everything works fine when we execute the DTS pac...more >>

I'm trying to export the results of a query to an excel worksheet that already has formatting defined on the columns. There are two "header" rows already present in the worksheet and these have different formats that the actual data that I'm exporting. The data transformation seems to work OK putt...more >>

I want to move my sql server 2000 to new hardware with the same name. In particular, i have to move the DTS packages (and there are a lot of them). I have tried looking this up on microsoft, but haven't found the proper article yet. Is it possible to give the new server a new name, use the co...more >>

If there is an FAQ, then can someone please provide the link, otherwise here's my question: I want to make a DTS package to import some data from Active Directory. Can someone point me in the right direction please? Is LDAP the best way to go? Thanks Mike ...more >>

Hello all. I'm trying to Import (using DTS wizard) a fairly large file. When I get to the screen where I specify the starting/ending column positions, the DTS wizard won't let me go beyond the 4095th column. My record is 4288 characters. Is there a limitation on the size of a record I c...more >>

I have created a DTS Package to import 17 text files. Two of the files fail consistently with the error: "System Cannot Find Path Specified" while the rest execute properly. All of the files are located in the same place. I have renamed and recreated the files to account for potential c...more >>

Hi, I use sql server 7. How i can modify DTS owner by another user or a group NT. Thank ...more >>

Howdy all. Im wondering if theres a way to do the following: Source .txt file; col1 col2 col3 col4 Destination table1; IDCol Identity column col1 col2 Destination table2; IdCol value from table1 col3 col4 The problem is getting the ID value for table2 I can use either a G...more >>

I'm a newbie to DTS and I have two questions: 1. How would I go about updating existing records using DTS? FOr example, I have two data sources, one is being updated regularly. The other one is just a "copy" which I am loading records from the first table into periodically. The problem is...more >>

I have a view that will generate approx. 100 million records. I am using a DTS package to append to a table from this view. I have disabled Transactions at the package level, and set the batch size to 1000 and the fetch size to 1000. The database recovery mode is Simple. Even with all of...more >>

Do these have to be designed in the DTS Designer, or can they be written somewhat differently to the GUI in Enterprise Manager? ...more >>

I have a simple DTS Package that imports data from an excel file in a table. When I execute the package it runs smoothly, when I schedule a job for it gives the following error: Executed as user: Administrator. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteS...more >>

Hi I have an 'Execute Package' task for which I need to make server name, username and password configurable. I have INI file from where I wish to configure above properties. My problem is, I am able to configure server name and username from INI file but I can not configure password. The server p...more >>

Hi, Can you please tell me why this wont work in an ActiveX task in a DTS package...? --- Function Main() set WshShell = CreateObject("WScript.Shell") WScript.Sleep 1800000 set WshShell = nothing Main = DTSTaskExecResult_Success End Function --- Basically I need to wait 30 mins with...more >>

is there a way to safely run the most recent version of a package, without using GUID ? Having to cut-and-paste from DTSRUNUI is not the best approach in a corporate environment, where automation and segragation of duties is a must. I've run a few tests with DTSRUN /S svr /E /N pkg Wi...more >>

I have a DTS package on a server which creates a text file out of a complex query. When I transfer the DTS package on another server, I can not keep the transformations even though I have the same database and the same destination file exist. Is there a way to transfer a DTS package with ...more >>

Is there a way to transfer by DTS both table definitions as well as the relationships from one database to another? ...more >>

Does anyone know how to properly export data to an Excel spreadsheet. I have created a DTS package that correcly exports to an Excel file UNLESS the filename already exists. It then stops on me if the file exists. I delete the file and the DTS runs correctly Any help would be much appreciated ...more >>

I have two connections.source is sql server, destination is Access. Before I transfter data to Access,(insert records to some tables) I need to delete the old records in the Access tables. I use Execute SQL task in DTS to delete records. But I found two things: One is when I chose quer...more >>

I have a problem with the SQL Server. JOB's we can access the DTS, jobs but cannot see the scheduals for these jobs when we try accessing this, we get: Error: 3624 Location: rebcase.cpp:1378 Expression: m_offBeginVar < m_SizeRec SPID: 54 Process ID: 1268 we have used DTSBackup to backu...more >>