Is this possible. I don't see it as an option. I have some rather involved transformations. I am moving the processing to another server and would hope that I could copy the package and then change some of the settings and save them on the new server. Can I do this? John Cantley ...more >>

hi, does anyone know how to change a dts packeage's owner name on sql 2000? we have individuals that creates dts packages on production servers, and we would like to change the dts owner name from the individual accounts into server's own account name. many thanks! JJ...more >>

I'm using the sproc below to create jobs(using transaction) in an automated fashion that will run cmdexecs after a configurable pause. This is potentially HIGH VOLUME! The sproc is run using the ADO.NET command.executenonquery method during the processing of text files to determine what th...more >>

I don't know if this is the right group. If not, please redirect me. I know how to create a database, complete with tables (CREATE TABLE ...). What I would like to know is if I know what values need to populate the various fields in a table, is there a way for me to automatically populate ...more >>

I have been having problems copying very large table (500,000 records or more) from a SQL Server 2000 database to a Oracle 9i database. I have been using DTS wizard to design a very simple data export. The DTS starts out working fine but usually after 200,000 records, I will receive this err...more >>

sql server 2000 we have a .net process that creates and executes a DTS package programatically. we are having an issue with memory consumption. both our application's & sql server's memory usage rise with each package creation and neither fall with the package release. by using GC.Collect() an...more >>

Hi, I have an web application where the use will trigger a process that has as one of the steps running a DTS package to load contents of a .txt file to a table in SQL Server. I have the package created and working fine in SQLServer (and when I have a windows application as well). But when...more >>

When I query the MSDN Library and Books Online for XMLScript, I get only one hit (Adding DTS ActiveX Scripts) that mentions XMLScript is available for use in ActiveX script tasks within a DTS package. But no details are offerred. Where can I get more detailed information on XMLScript (U...more >>

Hello, I have a problem removing an old DTS package from the Meta Data Services Packages in Enterprise Manager. Each time I try to perform a delete from the client interface the client hangs and refuses to delete the package. The delete option in the versions window is greyed out so I cann...more >>

I want to load data from a data csv file into a sql server table. This will happen on a regualr basis. But everytime we get the csv file it might have old records t oo. So I want to specify if there is a record in the SQL server table it should be an update else and insert. How do I go about...more >>

Hi , while i am trying to run follwoing bulk copy command set @x =3D 'bcp "select * from '+@SourceDatabase+'..users where = datediff(day,'''+CAST(@maxDate as varchar(30))+''',created) > 0 and = UPPER(howmadeaware)<>''EXISTING CLIENT''" queryout = \\10.0.0.253\D\SQLServerGenerated\output\int...more >>

Hi all, can anybody please how to reset passwords for an DTS? I need to edit and run it...but the former DBA left without giving us the passwords... Thanks, Tudor ...more >>

Hello, I'm trying to transfer data from a SQL db to a SLX SQL db with DTS. But when I'm trying to define the DataPumpTask between my MS OLEDB cnx and SLX OLEDB cnx, I obtain a message Error Hresult : 0x80040e14 without any string to describe the trouble. For info, here's the definition of my SLX...more >>

When I export a SQL table with a field that is defined as float(8) using a dBase5 driver the digits after 5th digit to the right of the decimal are dropped. Why is this happening? It doesn't happen when I export to a FoxPro database. Would it be the dBase driver driver? If so which driver sh...more >>

I'm using DTS to copy a database into a new database thats on the same server in MS SQL Server 2000.. The database is about 1.5 gigs... i'm wondering how long should this take? It's been about 20 minutes now and it's stuck at 22%, its been at 22% for the last 20 minutes.. is this normal? ...more >>

When using SQL DTS to connect to Exchange via the Exchange OLE DB Provider, what is the syntax of the data source. SQL Server 2000 and Exchange Server 2003 are on the same box. ...more >>

Hi, I am attempting to import data from an Excel spreadsheet into SQL 2000 I have 1 spreadsheet with 6 column headings ProdID, Customer, Vendor, EffDate, EndDate, FixedPrice I SQL Table with the same columns ProdID int Customer nvarchar Vendor varchar EffDate datetime EndDate datet...more >>

I've got a problem with the logging feature on DTS scripts. Each task in the log is identified with some sort of generic prefix, and then a very discriptive suffix: _1, _2, _3 or other such "meaningless" sufix I have no way to correlate with the specific task. (Why isn't this attribute shown ...more >>

I have to write a .Net application which can compare SQL Databases including things like: - DB structure, PK's, FK's, indexes and types of indexes i.e. should be able to detect if the same index has cascade set on one db and not on another, or unique on one and not the other, Constraints, ...more >>

*Please see the middle of the query for the question. I need to join in the --middle. I was wondering if I could do this with a where clause. Thanks!! /************************************************** **************** * * TRANSFORMATION 1A * Description: This Transformation will be ran f...more >>

SQL 2K Please provide any thoughts on handling DTS error while called from a SQL job. My SQL Job starts a DTS using dtsrun utility and when the DTS fails, I don't have much details. If I setup in DTS , Property -> Logging -> Error handling , will I get all the detailed error information...more >>

Hello again, So, in my vb.net app I run a DTS package from a button. No problem the first time. But if I click the same button to run the same package, I get an error message that a connection already exists. So I added an If statement with a static integer var. If var < 1 then g...more >>

Hi, I have mmoved a DTS package from one server to another and am having errors executing it va a web app. It runs fine when executed manually. It is executed through java by issuing an xp_cmdshell which in turn executes a dtsrun for the package. The java user has datareader/datawriter to...more >>

Hello, I tried running DTS to import data from a text file to a Sql Server 2000 table which contains an Identity column (autonumber column). I got an error that the Identity column cannot be null. I used to be able to import this file before I added the Identity column. Is there a way ...more >>

After installing XP Pro SP2 my DTS connections give me an error "Class not defined". All my connections that normally appear when trying to create a new DTS Package are not available. The DTS packages execute but I cannot edit nor create any new packages....more >>

Does anybody know what what SQL logic ist DTS using when getting data from FLAT FILE WITH WHITESPACE as a colum identifier ? What sp / view or whatever is used ? Michael ...more >>

Hi I DTS, in an FTP task can you access a secure ftp server....if so how do you do it.... eg I have a site like xx.xx.xx.xx on port xxxx with a specific username and password. How do you specify the port. I tried ftp://xx.xx.xx.xx:xxxx but it didn't work. Even ftps://xx.xx.xx.xx:xxxx didn...more >>

Hi, i try to import foxpro (.dbf) table with DTS of Ms SQL, but i have this error messagge "ONLY FOR SAME TABLE NOT TO ALL": Error calling OpenRowset on the provider I use Dirver for Microsfot Foxpro Why? Rgds Luca...more >>

Two questions: 1) What API does DTS use to access the database, OLE DB? 2) Using the DTS APIs....can I export a SQL table to FoxPro? to DBase?...more >>

Hello, We have a series of related DTS packages and We want to use one .ini file to drive all the Dynamic Property tasks for all of them. Once We get to approx. 6KB in the .ini file, We seem to hit a size limitation. The Section drop-down list in the Add/Edit Assignment dialog box trunca...more >>

Hi All, How can I execute the dtsrun command in the vb.net program? Please advise. ...more >>

Can anyone give me some direction in how to make a package to do what this script is doing? I have been checking the dts related web sites and groups and haven't found what I need to understand how to do this. BEGIN TRANSACTION DECLARE @ULogin varchar(50), @UPassword varchar(50), @UFirs...more >>

I have sp that I have written that gets info from a table. but it the text file I need header and results set. For ex.in the sp looks like this create proc info as declare @count int set @count = (select count(*) from info) select getdate() select * from info select 'total count '+co...more >>

Hi All When a number of my tasks fail I would like to send an email. I have set up a send mail task (that works fine) and I have setup a workflow of on fail got to my send mail task. My problem is that the package bombs out at the first sign of an error. The first place I looked was the pac...more >>

I have a package built in VB.NET being run from an ASP.NET webpage. It is pulling large amounts of data from SQL Server into an Access database for download by the user. I have two Web servers running this package and only one of them is getting the following error, while the other Web server ...more >>

hi, I am wondering if I can create a recordset in ActiveX Script and then Insert/Update data. e.g. Dim rst set rst = OpenRecordset("TableName") Do until rst.eof xx xxx rst.update loop the above statement work in vb/vba does it work in DTS, too? Thanks Ed...more >>

Hi, I have a ActiveX task that shows the error message as "invalid Task Result Value" But it used to be working fine. anyone have the same expenerice? Thanks Ed...more >>

Hi, I have cruised the archives but I can't find anyone with a problem enough like mine to help me out. I have a DTS package that works perfectly fine from within Enterprise manager. I can use DTSRun from the command line too, and it works perfectly. It has an ExecuteSQL task to clear a tab...more >>

Hi folks, I've had a look around and couldn't see a similar problem so thought you'd like a challenge (although this may be quiet easy) Scenario: Novell NDS directory showing the computers on the network and the users logged into them. Connect to this 'database' source with ODBC provid...more >>

I have a user who created a DTS package with an owner password. Now they can't remember the password. Is there a way to retrieve the password or better yet is there a way to change the password then remove it? Thanks for any help. Nancy ...more >>

Hi, I have MSDE SP3 installed and the only thing that I have changed recently is my Windows login Password. In the Enterprise Manager the SQL server is registered using mixed authentication. When I try to open any DTS in Design mode, I get an error dialog with the title 'DTS Design e...more >>

I want to change the connection information of a large number of dts packages when migrating from development to producton..... How can I do so? Thanks in advance... Ajay...more >>

is there some performance considerations when using execute sql task - is it better to use a large stored procedure compared to 10-15 execute sql task. michael ...more >>

I have some data that I would like to use DTS to import to a MS SQL Server table. Two of the fields contain packed-decimal data. Does an easy way exist to transform the fields into unpacked (signed) decimal during the import? Can anyone please point me to some documentation that would give some i...more >>

I need any script suggestion to use in my stored_procedure_load. Looking to load only the new data into staging tables since last_load_date. I wish to enter the last_load_date information into a table on each succesful load...and use the last_load_date info. in my query. eg. SELECT a,b,...more >>

I need to do ETL/ data movement. The databases are located in two servers. (e.g: Server_1 : 2 databases, Server_2 : 1 databases) I am using stored procedures for ETL loads into staging tables. How do I establish connection to different SERVERS using from my stored procedure. can any body...more >>

I'd like to get a string stored in a SQL table directly into an ActiveX Script. (More specifically, I am retrieving the name of a file which was the last one processed. The log of files processed is already in a SQL table. The table would be used to determine if the file has already been process...more >>

During the installation of our product, three things occur: 1- We install a version of embedded SQL Server; 2- We create our databases; 3- We generate a DTS package from a VbScript. This later step is the problem: on VbScript-generated DTS packages, the simple action of subsequently adding a...more >>

Is there a good reference to the DTS APIs besides the online books and the VB generated code in the wizard? I think I am going to be asked to write a few generic tools here for our group using the DTS APIs in a C++ application. Thanks....more >>

Hi All, I have a DTS package that queries a table and generates an Excel file. The excel file is saved on a remote file server. When I execute the package it runs fine and saves the file in the correct location. However when I schedule the package it fails. The error log states that Jet...more >>