Hello, Our .NET application runs in a shared environment managed by and ISP who hosts .NET applications. The SQL Server box houses several different databases for their clients (presently 123 different databases on one production box). Recently, when trying to DTS table changes from our devel...more >>

Hi, I have following workflow to be implemented in my dts package. s s s s s step1 ---> step2--->step3--->step4--->step5--->step6 Now If step1 OR step2 OR step3 OR step4 OR step5 OR step 6 fails i want to execute step7. As OR is not available, in orde...more >>

Hi, anyone know of anyway to purge DTS Logs up to certain date? The key thing here is I need to automate this job instead of manually deleting the logs from Enterprise Manager. Thanks in advanced rgds, Hoon...more >>

kindly provide a solution for taking backup on multiple machine, schedule based. *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

hi source tabl state yr2002 yr200 ----------------------- Andhra 1000 150 Karnataka 2000 180 Tnadu 3000 100 Kerala 2000 300 I want destination table thi State year noofcontract --------------------------- Andhra 2002 100 Andhra 2003 ...more >>

I will need to create a DTS to import an excel file. I will need 2 parameters( excel file name and an ID) How do you create the package with these variables. Thanks...more >>

I setup up a DTS import task using fixed fields. When trying to find out why some of my records were not being imported, I noticed that the records have lf (line feeds) right after the last significant field in the record. The programmer told me that the extract coming from SAP was 200 character...more >>

I have created a script thru SQL Server 2000 into a vb.bas file to execute a DTS transfer into an access database. Everytime I run the code the size of the access database is different. After checking out the tables in a very random fashion the Access database tables are missing record that the SQL ...more >>

The developers here wrote a DTS package that transfers 7 tables from DB2 to SQL. Every once in a while one of the tables on the destination, SQL, will be empty after the package completes. It does not cause the job to fail with a error. They asked me to take a look... The package is typical. Two ...more >>

I would like to schedule a user synchronization from Active Directory to another DB using DTS. Has anyone ideas on how to get started with this? Is there a way to make a DB connection object via ADSI to query it using LDAP? If I just can get that part to work, the rest is easy. / Fredrik...more >>

I have a DTS package that is set up to process the dimensions contained in my cubes. They are set to rebuild the dimension structures (and process). I have another DTS package that is set to process the cubes, and these are set to do a full process. However, I recently changed some of the dat...more >>

Hi! When we uses a search, where we use a expression for example (date >= 20040101) The SQL-server 2000 doesn't use the indexes we have created. Is there a problem using between values in a search? Can I force the SQL-server to use a specific index? Regards Jan Rockstedt ...more >>

Hello there, I am trying to create a DTS package, maybe a custom processing task, that would archive an Analysis Services cube periodically. I think is possible to schedule a cube processing via DTS package, but have not seen archiving the cube. Any ideas are hightly appreciated. T...more >>

I want to try modifying sp_add_dtspackage, as suggested by Darren Green at http://www.sqldts.com/main.asp?nav=1,6,212,0 ..but logged on as 'sa' - I can't edit it. Any ideas? Lewis Veale lewisdotvealeatpdms.com www.pdms.com *** Sent via Developersdex http://www.developersdex.com *** ...more >>

Hi, I've got a DTS package in SQL, it imports a text file into a table. I'm executing the dts from visual basic.net but the name of the file is inside the package, so I can't change it. Can I pass the name of file as parameter? the code in visual basic is : Dim pkg As DTS.Package pkg = New DT...more >>

When creating a dts package to export a sql 2000 db to ms access 2000, how do i include the constraints and indexes?...more >>

Hi this is my first time here, so be patient with me :) I'm looking for a way to parse addresses using sql transact, to store as a DTS. below are some examples: I would like to separate the street name and street type in 2 diff. columns. WILLOW CREEK PL RED BARN DR RED BARN DR CARRINGTON D...more >>

I have some DTS packages, which import text files into a database. The text file names change every month, so the packages gets re-saved every month - there are about 60 saves per month. The question is - will this fill up my sysdtspackages table? Do I need to consider truncating it occasional...more >>

SQL2000 i have a query file called text.sql saved into a directory, this file is recreated every night with new and updated info by another process. if i open and run this file in query analyzer it works fine. so what i now want to do is run the query in a dts package, i want the package ...more >>

I was given advice earlier this week regarding how to assign a returning value from a Stored Procedure into a Global Varaible from a Execute SQL Task. I must be missing the point as i still can not get it to work. The only parameter it is allowing is an input Parameter. Stored Proc ...more >>

hi guys, m having a problem with the stored procedure copied below. when i try to execute this stored procedure from query analyzer then i get the following error: Error: ---------------------------- Server: Msg 203, Level 16, State 2, Procedure EJ_GetEvents, Line 24 The name 'select sEve...more >>

How can I view the DTS log and login information. Pls help. ...more >>

Hello all I included a dynamic properties task in my packages in order to dynamically set the package logging properties based on a .ini file. Unfortunately, while this dynamic logging works when I execute the task from Enterprise Manager, it does not work when the package is executed from a SQL ...more >>

Hi All, I am trying to import data into a table on my SQL Server 2000 SP2 database using a text file source also created by SQL Server 2000. I launch the Enterprise Manager Import/Export Wizard and i go through all the steps for importing the data and as soon as i click the Finish butto...more >>

If I cannot copy the dt stored procedures when using the copy db task in dts to copy databases, how do I copy these dt store procedures? I believe every db needs to have the dt stored procedures, correct?...more >>

I need to be able to allow a non-technical user to kick off a DTS job whenever she needs to. Is there a way to call a DTS job from the command line, or a stored procedure that I can call from a web page? Any help would be greatly appreciated. ...more >>

Is there a table that I can access through a query that will allow me to look up the job log history of jobs run by the SQL Server Agent? I have a DTS package that runs nightly (via a job) and would like to create a query to pull success/fail information from the job history. Thanks, Chet ...more >>

Hello I Have a simple Qeustion I want to get in an ActiveX Script the last error message because I'm starting this script when the last Task falls. In this script I send a mail to me what was the failed step, but I can't read the really reason and I ever have to look into the DTS Pakage wha...more >>

The dt stored procedures are not getting copied when I use the Copy SQL Server Objects task to copy a DB from a server to an instance of the same server. Everything else are been copied fine. Any idea? Thank you....more >>

Hello all, Here is the problem i am having. I have created a DTS package to deliver XML data to an external file using msxml. I use a VB.net to run the package. When i created the 1st version, I hard coded in the stored procedure i use for the data and the delivery location and every...more >>

Howdy: I am doing a straight DTS SQL server(8) to UDB(8) copy of a test table that contains 3 columns, all are integers. No complications. No matter what I try I always get the same error: Error Description:[IBM][CLI Driver] CLI0150E Driver not capable. SQLSTATE=S1C00 Any help would be grea...more >>

Hi I have a data pump , I have a Active X Script to populate the destintation Table I want to insert rows based on a condition for eg Only If the salary >100000 I want to insert a row other wise I want to fetch the next row and do the same check and so on The problem is the destination h...more >>

Recently I have been asked ina interview what is dtslookup. Can any pls give some idea, or point ot a good pointer. TIA, ...more >>

Hi , I am a newbee to the dts world, I want to know how to run a dts package through a job. THanks a lo.t. ...more >>

Hello, I'm newbie in dts and i try to export date from msde2000 to excel with vb.net or c#. So i defined 3 steps in my programm 1. Drop table 2. Create table 3. Add Data Vhen i execute this program, the data are not deleted in my spreadsheet but it continues to append rows to existing...more >>

Hello, I'm newbie in dts and i try to export date from msde2000 to excel with vb.net or c#. So i defined 3 steps in my programm 1. Drop table 2. Create table 3. Add Data When i execute this program, the data are not deleted in my spreadsheet but it continues to append rows to existing...more >>

I have a situation where I have to get delta rows ( less than 1000) from a remote SQL Server at different physical location to local SQL server. I can either establish link server and use 4 part distributed query t get data OR use DTS transform task to get data. After getting data I will be using it...more >>

when we save a package what is this option meta data services used for and when do we save our package as meta data services TIA. ...more >>

Here's what I am looking at. I have a text file, tab delimited, that I need to bring into a SQL Server 2000 table. For the sake of arguement, the file will be like: Number,Code,Notes I need it to search the table, find the matching number and Code, then append the notes. The caveat is t...more >>

I could display rowset values one by one as follows. But How to hold the rowset values in an array of a global variable? ie. rowset = select a,b,c from tabl Set oRS = DTSGlobalVariables("RSTables").Valu msgbox oRS.Fields(0).Value ' msgbox oRS.Fields(1).Value ' msgbox oRS.Fields(2).Value ' ...more >>

I have a dts package on dev. server, what are the diff. ways I can move this to production box. Thanks in advance ...more >>

who can tell me some free newsgroup server Thanks ...more >>

I have successfully created a DTS package importing data from sybase database to a SQL server. In fact it can be run very well mostly. But when I run the DTS package at command prompt but not at Enterprise Manager its very unstable in course of it will hang sometime. Can anyone tell me wheth...more >>

Basically i have a bunch of excel files that must be uploaded to the database about one a week so i'm trying to create a Dynamic DTS package. The first thing i need to do is convert the files over to text(CSV) then upload them to the database. Right now i'm stuck on the conversion. I have 3 glob...more >>

Hi, I used DTS Export Wizard to copy tables from SQL server 2000 to Oracle 8.1.7. After transfering completed successfully, I loged into oracle and tried to select data from the tables. I got 'table does not exist' error. But when I select table_name from oracle data dictionary, I saw tables e...more >>

Hello, I am very new to DTS, so excuse me if my question has already been asked a million times. I have a view that is a combination of many tables, and on a periodic basis, I would like to export this view to an excel document automatically. The problem lies in that the fields in this view c...more >>

Is there a way to have DTS open an internet browser window and then save the file to a temporary location on the local hard drive?...more >>

All, My DTS calls a sybase stored proc which returns 2 resultsets. They should be mapped to 2 different tables A & B, respectively. How do I do this? I am using SQL2k. Regards, -j- ...more >>

i am trying to import data from an access table into a SQL table in a database and am getting an error which says: "Error at destination for Row number 151" "Cannot insert duplicate key in object...with unique index... The funny thing about this error is that I am only importing 100 records/rows. ...more >>

Hi , i would like trace a restart of DTS. It is possible ? ...more >>

I have a database sitting on SQL Server 2000. Within the database, I have a list of specific customers and their 'keys'. What I am wanting to do is get additional information (Data) from an Oracle Database, and am wanting to pass in the 'keys' from SQL Server to Oracle to retrieve the data For exa...more >>

Hi, I need to import to a data base from various text file using the DTS. The files are in the same folder (for example: C:\TEMP\) How can I do that? Best Regards, Jooão Correia...more >>

Hi Sorry if this questions has been beat to death, but I am new to SQL server and I have this problem I have 7 jobs made up in DTS to transfer data from Foxpro tables via query over to SQL server tables (created using the DTS Import/Export Wizard). Now each one works fine when I run them imme...more >>

i have a stored procedure that counts the number of records in a table and returns an intege ie CREATE PROCEDURE TESTSP @RTNVAL INTEGER OUTPU A Set NoCount o Select @RTNVAL = Count(*) from Table If @RtnVal > 0 begi ...more >>

I would like to update some data within existing tables. I currently have data that is in tables but i would like to update some of the fields. I run dts and it populates a staging table. From there i would like to update the last table with the update data from the staging table. The existing data ...more >>

I need to create a folder with the date on it using VBS in DTS. If I created one today, it would be named "2102004". I need it to be "02102004". I can acheive this using my example, but it seems as though there would be a better way. Plus searches would be really tough. Function Main() ...more >>

Hi, I have a table with 18 million rows. I want to load data from production to dev. I created a DTS pkg. Dropped all indexes on that table, disabled trigers. On the DTS Package properties : Advanced Tab, I have these options checked : Transactions Checked "Use transactions", "commit on...more >>

I have a DTS package setup to process my analysis services cube and a job scheduled to kick off the DTS package. I can run the package fine interactively, but when run from a SQL Agent job the following error is returned in my log file The execution of the following DTS Package failed: Error So...more >>

I am trying to pull information down from an Oracle database. Running a basic select statement in a ExecuteSQL task runs fine, but adding a TransformData task from Oracle to SQL hangs. I can add the connection to Oracle I can add the transform data task line But when double-clicking on the ...more >>

Hello, I have a series of DTS Packages that perform multiple tasks, including a few data pumps. I want to be able to trap a specific error (Error appears in the log) and perform some possible cleanup or retry logic before the entire package fails. Currently I am just forcing a failure of the...more >>

Hi all, sql server 7 its an web assistant DTS job we are getting the below error. Unable to perform a SETUSER to the requested username 'dbo' because the username is invalid for database 'catalog'. The step failed. waiting for reply TIA...more >>

I am using the DTS Query Designer (SQL 2000-SP3) to get data from an MS Access 97 database. If I add more than 2 tables and join them together, the Verify SQL command give me an error message as follows: ADO-syntax error(missing operator) in query expression 'Subcontract.[Subcontract ID]=[Invoic...more >>

We are tring to use a proxy account to execute jobs containing DTS packages which are owned by non-sysadmin accounts (developers). The package will run standalone, but when placed in the job, it will fail with an error which indicates the directory name is invalid: DTSRun: Loading... Err...more >>

Morning... I have a current process that uses a ETL Tool Data Junction pulling data from a .TPG file into SQL Server 200 We would like to rewrite this process and use DTS. Does anyone know what kind of file .TPG is and can DTS read it Thanks for your time....more >>

I have been stuck on this for the last week... I cannot create a new database on our Sql server, I have recently taken over management responsibilities on an existing SQL server (2000). Apparently at one time, it had the Adventure Works CRM database on it that has since been removed. I was t...more >>

I'm trying to update all connections in all dts packages on the server if the specified value is found in the connection data source. The code seems to work fine as in there are no unexpected errors or halts except that the change doesn't actually occur. After the script runs seemingly ...more >>

I'm trying to update all connections in all packages on the server if the specified value is found in the connection data source. The code seems to work fine as in there are no unexpected errors or halts except that the change doesn't actually occur. After the script runs (with no unexpected erro...more >>

How do i run DTS from a command prompt...more >>

Anyone know the equiv M$ command that does table locking such as below? This code snippet is from Sybase and I need to convert it to M$ SQL2k - SP3. /* Lock the tables that will be transferred TO DW. * The locks will be removed when this stored procedure * is exited. "mode wait" means wait pat...more >>

Hi, I am importing data using DTS from .csv file into SQL table -Table_with_Good_records. SQL table has constrains on some column. How can I write rejected records (didn't pass conditions, duplicate PK, etc) into the another SQL table - Table_with_Rejected_records. Thank you. Leon ****...more >>

Hi, I have bunch of data from an excel spreadsheet that needs transforming from a row into the column names for a db, can I do this with DTS. Also, how can I tell DTS not to import row data with null values?...more >>

hi, i have an access project with a rather complex vba code. This code was used to load input files into the access database. The problem with these files is that they do not have a cr/lf specified, so I had to write code to parse the entire file and finding specific keywords within the file so I ...more >>

I have no ActiveX skills, so I'm hoping this is going to be easy for those that do. I have a Global Variable (type =Date) in a DTS, which I want to set to the current date (minus the time - ie convert(varchar,getdate,106) ) at the beginning of the DTS. How do I do it?! Thanks. BM ...more >>

When I tried to create temp table with the script below in the package, I got an error " invalid object name: #Heloc Rates." I have right to create temp table. Please tell what I did wrong. I am new to DTS. Your help is greatly appreciated, Culam CREATE TABLE [#Heloc Rates](code_ V...more >>

sql2k sp3 Ive got a DTS package that creates a folder with the current date on it and replaces the /'s with an empty string. A small example; Function Main() dim folder folder = replace(date,"/","") msgbox folder Main = DTSTaskExecResult_Success End Function However if run toda...more >>

Hi, Guru: Is there any way to delete a DTS package, I mean, not from Enterprise Manager? Did anyone try SQL-NS or have any other source code? Scenario: I have a VB coding which creates a DTS package and then saves it to SQL Server, but somehow there is a existing old DTS, at this point, ...more >>

I am trying to pass a global variable value into the variable @RPT_BEGIN_DATE in an "Execute SQL" task. The variable is part of the WHERE clause. The "Execute SQL" task is as follows: declare @RPT_BEGIN_DATE datetime -- Generate report detail for failed jobs/steps insert into T9801_...more >>

due to the solution no. 3 to add code the active x where i add it?? please help me because the solution no.2 it's not work...more >>

Kindly advice on how to use sql search option, in detail. Thanks in advance *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

I have 4 Data Driven Query Tasks executing within a Package. All of these perform inserts/updates/deletes on destination tables using data sourced from staging tables within the same database (so the Binding and Destination tables for all 4 Tasks have the same connections). When more than one of the...more >>

Hi there I have a DTS package which delete records from tables (around half a million records totally). Data is fetched from different sql server using datapump to local temp tables. Now the temp records that are imported from different SQL Server are copied to production tables using "Insert i...more >>

Hi, I have a problem with ini file. I use my ini file to get an oracle database connection information The file looks like this: [oracleConn] source=serverName user=username pass=password The problem is that the dts process does not refresh the connectio information when the ini file ...more >>

I obtained a return value from a store procedure. What T-SQL command can help me to write this return value into a .txt file on hard drive? Thanks for help. -Tom ...more >>

I have a data source that has a column for Time xx/xx/xxxx which through DTS i can convert without any issue into the data field. There is a second column HHmm which is military time. Whenever I try to do a conversion to datetime i get an error even if I specify the transformation as a datetime ...more >>