First, this is an abuse of cross. Second, you have future-posted. Hopefully everyone will ignore your post until you show a little courtesy. ...more >>

I need to import an Oracle Database into SQL Server 2000. I know this can be done easily using DTS but I do not have access to the Oracle Database, I only have an Oracle Database Export File. The Export file has been generated using SQL*Loader. ...more >>

Hi, I have build my own custom transformation and tested it by copying a source table with 50000 records to the destination table. The records were copied in a strange order. Is this a normal SQL server behaviour, or is this issue related to my custom transformation? Regards, Blaz Ziher...more >>

hi, Based on Sql server 2000 sp3 , I use dtsrun command to run a structured storage file from a remote machine and get below errors DTSRun OnError: ExportData_Step¡AError = -2146959361 (8007FFFF) Error source: Microsoft Data Transformation Services (DTS) Package Help file: sqldts80....more >>

I have to export date data to a text file for use on a UNIX server. The programmer is asking for the date field to be split up into two fields. YYYYMMDD and HHMMSS If I convert the datetime filed to a string using eithier of the MONTH, DAY, YEAR or DATEPART function it drops the fill ze...more >>

I have a master control package that execute a bunch of other control packages which then execute actual DTS code modules. The problem is that a specific DTS packages fails and then returns a fail to the first calling control package which then traps the failed state and then it is supposed...more >>

I've got the problem. I created DTS package that copy data from SQL Server to the text file. The DTS successfully execute from 'Data Transformation Services', but when DTS schedule to run in SQL Server Agent it gives me the error. DTSRun: Loading... DTSRun: Executing... DTSRun OnSta...more >>

I have a strange problem that I am having trouble troubleshooting. I need to execute a SQL commend against an Oracle database using DTS. I created a 'Microsoft ODBC Driver for Oracle' connection and based an 'Execute SQL' task on that connection. When executing the task I get the "Multiple-ste...more >>

Hi, I have finished my Database along with Tables, Views, Stored Procedures and Constraints. Is there an easy way to push 1 button ;-) that will export the complete database into a SQL Script? I want to add this to the root of the application so I can easily setup other DB in the future?...more >>

A remote office developed a PC-based app that writes its data to a text file. We want to maintain this data at the main office, and in SQL Server, due to the significance of the data. A typical day's file may have a couple hundred records, written over an eight hour shift. Rather than changing...more >>

Hi, When i execute the same DTS job on another server not running SQL Server I get the following errors. But if i run the job on the same server as the SQL Server it works. This is driving me mad - please if anyone has any pointers. Regards Toby. C:\Documents and Settings\Admi...more >>

Hi, I am pulling my hair out trying to figure out why I can't sink up dts package events in VB.NET when referencing an RCW that is around the dtspkg.dll. The code in this article works fine when just referencing the dtspkg.dll directly from the VS.NET IDE. http://support.microsoft.c...more >>

Hi, I have to update 9 tables on my local SQL Server each night, built with the data from two remote databases (1 SQL Server and 1 FoxPro). The data in these remote databases contains duplicates. The method I have chosen is to create a DTS package on my local machine, which creates 9 temporary...more >>

Hello: Does anyone know of an example showing how to import a delimited text file into SQL via the DTS api in C++??? I can get this to work from VB but when I translate it to C++ it doesn't work, even though I get a HRESULT that succeeded. It is so frustrating!! Short of posting the code he...more >>

Does anybody knows what is the max number of rows when using BCP and if there is any way to change it??...more >>

I am using DTS Wizard to Import data from Excel to a new table in SQL server. After import, I notice that some data values in Excel are replaced by NULL in SQL table without any warning or error. That makes me very nervous. It means that I cannot reply on the DTS successful import. It's ea...more >>

Hello. I have a text file with names, addresses, email, etc... It contains over 700,000 records. When I use the DTS text driver I only get just over 400,000 records. If I Import the data into MS Access, I get the full 700,000. I looked at the file in at Hex editor and the row Identifier...more >>

I have 2 servers , so server web and sql server I not executing um package in page asp When open browse page , o job failed. I create user no AD , with permissions this page ANyone have idea ?...more >>

G'day, I've created a data transformation task to load a delimited text file into a SQL sever table. Some of the columns of data which have a FK constraint can have NULL values. This shouldn't be a problem however I'm getting errors on those records with 'NULL' values. The source file is comm...more >>

I am creating a DTS package to archive records from one table to another, given a certain lower and upper row count. These lower and upper values need to be dynamic, and if possible used as global variables. In essence, in VBScript I would like to have the individual executing the package to b...more >>

I configured a computer a work to be a 2K server and installed SQL 2K on it and I have been using it for testing purposes since 7 months now. This morning I loged in as Domain Admin to the server and tried to access the SQL server and I got the error message "Cannot generate SSPI Context". A...more >>

I am trying to refresh data in a table from one SQL database to the other SQL database weekly. Each database is on its own server. The table on the database on each server is identifcal. The key in the table is an identity key. Here is what I need help with. Since I am refreshing the...more >>

DTS load jobs executed successfuly but no data. I have dts paackages for loading data from one sql server database to another sql server database, there are 8 tables being loaded daily and they run by sql server agent job. I used simple simple copy transformation on all tables. I have used an ...more >>

Normally when you read in an Excel file through DTS you read it in by row. I have a file that is setup as a cross tab report that I need to read in. This is how it is in the spreadsheet: Jan 05 Rebate Rate .017 Int Rate .010 In the database I want it...more >>

I have a package that I am using to take data from a table in SQL out to an Excel spreadsheet. However, what I'd like to do is have the package put the Excel workbook on an individual's desktop. I tried using the %userprofile% variable but the system is not accepting that. Is there a way to do...more >>

Hi, I have done a DTS package which pull data from a CSV file and copy the contents to a SQL table. On the text file source I can put a CSV file which is in another server and when I run it from SQL enterprise it works fine. Then I have created a ASP.NET application. I have included a inpu...more >>

Hi all, When I run a package with dtsrun utility I wanted other users to run it also and provide the necessary global variable parameters but not be able to view or edit it. However, it only works correctly when the owner password is provided in /M. If I use the user password in /M, the ...more >>

can anybody show me how i can run a sql query and insert the data into a send mail task The sql statement will produce the following out put Live ordred Cancelled 12 23 11 i also need to put some a small message before showing the results. any halp will be ...more >>

Hi , I have an existing MI System that uses a third party command line application to retrieve and store data in text files , i want to automate this using DTS . The third party command line applications expects one param at a time , is it possible to design the system using DTS , in which...more >>

Hello, I am creating a dts package programmatically in a vb.net windows program. While executing the package i sometimes get the error "Code execution exception: EXCEPTION_ACCESS_VIOLATION" The Dts is not executing in the main thread as below. oStep.ExecuteInMainThread = False ...more >>

Hi, Using SQL server 2000 on Windows server 20003. I need to copy table(s) from one database to another. I have created a Copy SQL Server Objects Task to do this. However, I need to have a user run this from Access VBA. I would like to have them input a table name, press a button and the t...more >>

I created a package to export data from one source and output as text file. It worked successfully if the output text file is on this 1st PC as the SQL Enterprise. However, if I change the output text file to be on 2nd PC and I execute the package , the error will come up. I've mapped the ta...more >>

Hi, I have a bulk insert question. I have a standard transform data task that copies data from one database to another. As part of the insert, I am sending some data that needs to be split out and transformed slightly and inserted into another table (there could potentially be more than one...more >>

I'm, trying to create a ASP page that launch a DTS packed after setting a globla variable for the import file name. I need to import only today (2005-01-18.CSV) file, so the DTS first delete today records than import the new file. If I use a fixed file name evrything is fine, but using a glo...more >>

I am having a heck of a time SAVING a View when using a LINKED Database Table. From Enterprise Mgr, I create new View, Add the Tables or Views, also dragging a View from a Linked Database Table and Run it, it works fine. When I try to SAVE that I get an Error Message of: --------------------...more >>

Hi, I've been trying to debug ActiveX scripts that I'm using in my DTS packages. I have my DTS packages in SQL2000 . I have MS Visual Studio 6.0 and InterDev installed on my machine which runs on Win 2000. I have checked the "Enable just-in time debugging" option. I have a STOP statement...more >>

Does anyone know of any tools and/or utilities that will document a DTS package. I have a bunch of them that I need both a high-level and detail documentation for auditing purposes and change control. Any help would be appreciated. ...more >>

I have a scheduled job with 6 steps like DTSRUN /s<SERVER> /e /n<DTSjobname_import_from_Access_MDB> The job fails on these steps if users are in the Access system which the DTS jobs import from. If no users are in, then the scheduled job runs fine. If users are in the system the DTS jobs ru...more >>

....Not enough storage is available to process this command. The file I'm try to import is a text file. There are 874,000+ records and each record is 856 bytes long. This is for SQL2000 I have successfully imported previous files from the same source with more than 900,000 records in the...more >>

....non-whitespace characters were found after the last defined column's data. Here I was attempting to import a text file where each record is 730 bytes and has 49 fixed-length columns. Are there restrictions to how many records and how wide the records can be imported in a DTS package? ...more >>

Hi all I am generating an error in one step so the dts execution will flow to a different direction than the one it would normaly choose (on that step's success). The thing is that when I schedule it in to a job the step's failure fails the job.. although the package continues successfuly to...more >>

I am calling a DTS from a stored proc. when I FORCE a task to fail (testing) the following code does not return an error...it will always return 0 therefore never going inside the if statement. --Executing the Package: EXEC @hr = sp_OAMethod @oPKG, 'Execute' IF @hr <> 0 BEGIN SET @s...more >>

Hello, I have a DTS Package that, when I launch it manually, it runs a directory to directory FTP. The source is a local directory and the destination is on a whole different server on a diffrent domain. I map the x:\ drive using "login as a different user". the files goes and all i...more >>

One of my servers needed to be rebuilt recently and a new C drive was installed. SQL Server (7) was lost although the DATA was held on another drive. So I installed SQL Server 7 again, on the C drive as a clean install and then imported the tables.... But now I seem to have lost all mt D...more >>

I have the following problem with my custom transformation: sometimes (I have no clue, what the reason is) it doesn't end its work. It just goes on and on for ever, eventhough it might work just fine with the same properties some other time. Did anyone else encounter anything similar? I can...more >>

Hi: I have two queries shown below. They both use cursors created from the same table (but with completely different data), and they both write to the same table. Problem is, when I run them back to back in Query Analyzer, the first one will execute and insert rows in the "CallByCallYesterday...more >>

Hi, I need to do the following through Enterprise Manager (EM). I need to copy the structure of all the tables along with their PK, FK etc and need to copy the data of only select set of tables (not all of them). I tried doing this in EM but lost the relationship between tables in the target ...more >>

i use BulkInsertTask to import txt file programly,in vc++, how can i get number of rows imported ?...more >>