Hi All, I would appreciate it if I could get some opinions on my proposed solution. On a nightly basis I have to execute a batch job that would does the following 1) Execute a Stored Procedure to return a recordset of IDs from a SQL2K DB (Can be up to 750,000m rows) and insert these ids in...more >>

I am converting an Access Database to SQL. My problem is that I have many different source fields I want to put in to one field (CaseNotes,Notetext) in the DTSdestination but I want each to create a new recordset. Right now the last transformation to take place is the only one I can see when e...more >>

I'm very new to DTS, but here goes: I've got a source file with dates stored as YYYYMMDD, and I'd like to move the data into a datetime field. I've figured out the basic transformation steps, but I'm running into a problem with source dates = '00000000' (e.g. obsolete_date = '00000000' for p...more >>

I've come across a Transact-SQL statement as follows: -- Statements start here select 'EXECUTE sp_changeobjectowner ''' + name + ''', ''dbo''' from sysobjects where type = 'U' -- end here Questions: (1) How should the 'select' statement be interpreted? (2) What are the rules for u...more >>

I have a VB.NEt Winform app deplyed on ServerA. I have a DTS package on ServerB. When I try to load the package with: package.LoadFromSQLServer(serverB, uid, pwd, DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, , , , packageName) Where serverB, uid, pwd are variables set in the program...more >>

Does anyone have any tips for debugging a DTS package? I've enabled JIT debugging. It launched Visual Interdev for me to step thru code. Problem is -- I can't change anything. Guess this is how it works. When I stop debugging, the debugger stays up but Enterprise Manager closes. Is t...more >>

Hi, I am looking for the dts run time. Is this information stored anywhere in the database tables (package name, how many mins etc..) ? sql 2k, win 2000 Appreciate the responses. Thanks....more >>

Hi all -- I'm trying to write my own ActiveX transformation script to copy some fields from an old table using a couple different data types to a new table. I seem to be having problems with the different data types and can't get DTS to run with them. I'm sure it's just due to my in-exper...more >>

I have some .dts files but do know how to open them, anyone knows , thanks a lot. ...more >>

I am simply trying to run DTSrun.exe from the Job Agent in SQL Server and everytime it Says that the job failed. The job failed. The Job was invoked by User CHQPVUW0806\LenceRM. The last step to run was step 1 (cmd). The step failed. This happens every if I just try to run dir or and ...more >>

Hi, I am writing an installer for a database driver application. The installer is supposed to create the DB, tables and populate the tables with sample data from an excel file. The excel file containing the sample is generated via the DTS wizard from an existing production DB. The applic...more >>

We have a situation where we having a training database on the same instance as the live database. At irregular intervals, a user needs to copy recent live data over on to the training database. In the past, this has been done by the user restoring the latest backup over the training database,...more >>

I'm having a problem running a DTS package in VB. Everthing works fine on our development PC but when we install on our test PC the package seems to run (ie we're not getting an error message) but doesn't transfer the data to the table in SQL Server 2000. I've tried both calling the DTS pa...more >>

Hello, I have a similar excel sheet: company_name site_name CompA site1,site2,site3 CompB site4,site1 CompA site5 .... I want to transform into sql "company" and "site" sql tables. (each tables have uniqueidentifier ID column and the ...more >>

Hi: I have a script below, when I run it on its own, it is great, but when I run it as an "Execute SQL" task as part of a DTS package, the step fails with a "division by zero" error. Shouldn't it ignore this error due to setting ANSI_WARNINGS and ARITHABORT both to OFF? I get the error in Quer...more >>

Hello All, We developed a DTS package that would pull records from 12 different source tables and inserts into 12 different target tables. For this, we created 12 different "Transform Data Tasks" that run in Parellel. However while testing we found that it Transfers only 10 of the tables...more >>

Hello, I am trying to use DTS to move an SQL Server database, from one server (A) where I have sa access, to another server (B) using the DTS wizard. I have db_owner access to the database in B I am transferring data and objects to. I am able to successfully perform the operation between...more >>

Is there an easy way to change the source path for a DSN using the DTS object model? I have a DTS to import DBFs into SQL. Because I want to do some complex join queries with the DBFs while importing I cannot use the native dBase connection object. I am using a DSN with the Visual Fox...more >>

I have a VB program that moves data down from a SQL Server to an Access database. Each time the DTS runs the WHER Statements may change on the selects where it is pulling data for different customers. The entire package will excute without hitch sometimes and fail at other times although neve...more >>

I am pretty new to SQL server. I have setup a DTS package that would delete and then copy data from SQL server to DB2 on mainframe. I installed the Host Intergration Server 2000 client to get OLEDB for Db2. The DTS is working fine, when I run it myself from the server. But when I schedule it i...more >>

Hello. I need to import an EDI TS-130 file (that contains academic transcript information) into SQL Server 2000 via a DTS. Under "Data Source", what should I indicate? Do I need a third party tool? Thanks....more >>

Hi, I need to import various excel files into sql server. All Excel files have different column names. To my datapumptask I want to provide column mapping dynamically using map tables. One map table will be maintained for each excel file. map table will contain mapping between excel column na...more >>

Hey all, prolly a simple solution, but why isn't the following string working in my execute sql step? select x from new_files where x like '%[^0-9]%' and x like '%[^a-z]%' Actually, it does work, however, it's displaying all the records? It should only be displaying those records that do *n...more >>

Someone can help me,Does anybody know the physical path of the DTS packges?, because I can not start operation system, i just have access to one partition of HD. I wish know, if posible to copy msdb files and paste on another PC(backup) without lost DB's -- Message posted via http://www.sqlmon...more >>

How can I pass two Global Variables in a dtsrun command? I'm using coldfusion to run dtsrun with arguments. <CFSET sArg = "/S ServerSQL /U userName/P pwd /N Import Text File /A FilePath:8=#cffile.serverDirectory#/#cffile.serverFile# /A UserUniqueID:8=sampleTest "> <CFEXECUTE name="C:\Progra...more >>

Howdy, I need to call an Oracle package, that does some process on a Oracle Database and outputs 0 or more rows in a ref cursor. Is it possible to call this oracle Package in a DTS Package and to insert the returned ref cursors rows in to a SQL 2K DB Table ? I am connecting to the Oracle...more >>

I have a package in which I have several Data Pump tasks to copy data from a tables in a Pervasive Database to an SQL Database. I use a dynamic propertice task to change the destination connection (server name and database name). Dynamicall changing the connection works fine for other task...more >>

Does anyone have a way to install both a DTS package and/or a DTS Custom Task via InnoSetup? ...more >>

Hi All, I'm importing a text file to a table. I only want some columns info from the text file so my transformation looks like this. DTSDestination("AddressCountry") = DTSSource("Home Country") DTSDestination("AddressZip") = DTSSource("Home Postal Code") DTSDestination("AddressState") =DTS...more >>

Hi, I've created some DTS packages and they are scheduled every 30 minutes. There are send mail tasks in the execution flow - about 60 total send email tasks contained in 7 DTS packages. Now the admin has decided to restructure our server system. The new architecture will have without Out...more >>

I've tried to use Oracle 10g Instant Client driver so I can transport data from Oracle to SQL Server without success so far. Anybody can enlighten me on this subject? Thanks in advance. 1. I downloaded and setup Instant Client according to Oracle documentations. I modified PATH, added a few...more >>

Hello, I am working on an application that interfaces with an AS400. The AS400 programmers I am working with at the client, are not very flexible. They are providing me with data for the initial database load for the application to go live. After that my app will take care of all data manipu...more >>

Hello, I have a dts job, based on a Transact-Sql BACKUP command, which produces regularly a backup file. Immediately after it, another task should compress (zip) this file. Which is the best way to realize this and which compress programm must be used so it is compatibel with WinZip? T...more >>

Hi everyone. I have a question that maybe some of you may be able to shed some light on. My set up involves three SQL Server Databases. First one, used by the application. Second, copy of first via log shipping. Third, contains data aggregation from the Second. Now, my issue is that I ha...more >>

I'm working in an environment where there's a need for certain users to be allowed to execute a pre-made DTS package to update a database. Running a schedule for the update isn't sufficient because at times it may need to be done immediately. What is the best way to allow a user without Enterp...more >>

Hi all and happy new year. I've got a problem to join transactions in a package. In a package, I've got two OLEDB connections to the same database (sql2k) to tranfer Data from one table to another with a DataPump. I've checked 'Join Transaction if present' in the workflow properties of my ...more >>

Hi All, I want to execute a package from a server that I dont have install sql using coldfusion page. What files can I include in this server so I can execute this package? <CFEXECUTE name="c:\program files\microsoft sql server\80\tools\binn\dtsrun.exe" arguments="#sArg#" timeout="1800"/> Tk...more >>

Hi, I would like to know if Bulk Insert Task is supported in SQL Server 2005. Also more specifically if there will be any changes to loading using the format file. thanx...more >>

Hello, I am trying to import log file from a monthly generated log using DTS. The problem is that the log file name changes every month and I want the text file (source) to change to the same file name. I have created a DTS like this: A. Set the current Text file path with a "Dynamic proper...more >>