Greetings All, Problem: Data in an SQL Server 2000 database needs to be sent to a DB/2 = database via a DTS [this part is easy]. However, the DTS needs to be = executed/run via a custom, user-friendly user interface other than = Enterprise Manager [e.g. the ole right-click, Execute package me...more >>

Have you heard about anything like this: "You'd normally see this behavior if you do not have the typelib or proxystub dll register on the machine where you execute this code. You should make sure that the typelib that contains the definition for your interface" I read a thread with t...more >>

Dear All! I have an access Database which have loads of Querys.And I want to import these Access queries into SQL Server Views section of the Database folder.I used DTS wizard but it copies all the Access Queries into the Table section of the Database folder and not the View section. Whic...more >>

Hello, I exported a package to vbscript. Then I tried to paste the code back into a new package using the "ActiveX Script Task". However, this didn't work. Is there any reason why this wouldn't work since it was created by the DTS package? -- Thanks in advance, Steven ...more >>

Hi, The statement CreateObject("MAPI.Session") always causes the error message "ActiveX Scripting Encountered a Run Time Error during the execution of the script" I wonder if it is possible to use MAPI objects in a DTS ActiveX Script? Thanks. ...more >>

My stored procedure runs great when I execute it from the Query Analyzer but when I execute it from my DTS package on the same data it stops processing after 15 or so records. Literally just stops. There are 278 recs in my test data and it has stopped on 12, 15, 16, 17, and 21. When I exec...more >>

I created a VB.Net appliction that creates and executes a couple of DTS packages. I use trusted connection in my connection objects. I then deployed these applictions to a user's machine. I had to create a login on the SQL server and promote them the the Serve Administrator role so they coul...more >>

Hello, I have a dts package that I created in Enterprise Mgr and saved on the main server (SS2K_Office). The package exports a database from SS2K_Office to our web hosting company (SS2K_WebHost). When I am at the office, I can update the package because I am on the office network and can go ...more >>

I created a MSSQL server database called "archives" in a network server machine called "BAA" I have one archive.mdb file in my local C drive (MS 2000 professional) with MSSQL server loaded. I open the MSSQL in my local laptop and connect the "BAA" and see the "archives", 1) then I us...more >>

Hello, I know that it is possible to put DDL statements (i.e. CREATE TABLE, DROP TABLE etc...) in transactions but I have found a peculiarity that I am trying to get around. I issued the following: BEGIN TRANSACTION CREATE VIEW TempView AS select * from tempTable COMMIT TRANSACTIO...more >>

I get an errror like this : Could not create an instance of OLE DB provider 'DTSPackageDSO'. OLE DB error trace [Non-interface error: CoCreate of DSO for DTSPackageDSO returned 0x80040154]. What does it means ? Is my syntax correct ? SELECT * FROM OPENROWSET ('DTSPackageDSO', '/Usa ...more >>

In the Copy Task of the DTS the procedure is as below: Public Sub Task_Sub2(ByVal goPackage As Object) Dim oTask As DTS.Task Dim oLookup As DTS.Lookup Dim oCustomTask2 As DTS.DataPumpTask2 Set oTask = goPackage.Tasks.New("DTSDataPumpTask") Set oCustomTask2 = oTask.CustomTask oCustomT...more >>

I am transferring some SQL Server Tables through DTS VB Program. The transfer is for a particular month's records, from one Server(source) to another Server's(destination) database. First it deletes the records from destination server tables, and copies the records to destination from the ...more >>

Hi, How to transfer data from certain data in the table in the Microsoft visual foxpro database to microsoft sql server database. What i need to do first? How do i compare the data in the microsoft visual foxpro database and SQl Server database and only update the lastest inf...more >>

Using enterprise manager to create a database export, save the task to vb file (dts.bas) I open up the dts.bas in VB and add the nec. references - the project won't compile until I correct some of the SQL statements, the when I compile and execute - in the weeds. The program reaches the execute ...more >>

I am not certain which group to post this to - sorry if this is the wrong group: I have a table that holds the location of various media and such (mostly images). One field is the Media name, the other is the URL in the form http://myServer.gunnery.org/media/pic1 for example. we are about to...more >>

I am sort of new at DTS. We use SQL Server 2000. I have created a DTS package that 1) using a Data Transform Task queries our Interaction table for employee data and inserts into iCreate_Author1. 2) Then using an Execute SQL Task runs the following insert query: INSERT INTO iCre...more >>

HI, I've created a package that extracts data from an Access database. There are three tables that are transferred to a sql database. So, I have an access connection, sql server connection , and a execute sql task. The execute sql task deletes the three tables. I have the sql task linked to t...more >>

I am getting the follwing error when I run a DTS. It fails on second DDQ, but when I run the same DDQ manually it is running fine.Any idea why [wall Data][Rumba Data access]communication link failure. APPC Primary RC= Parameter_Check;Secondary RC=Bad_Conv_ID....more >>

does someone know how to change the file sourse name in a run time? I have file:test.txt dependends on day of the week it will be changing to test1.txt, test2.txt... And also I have DDQ runnig for this file...more >>

I created a DTS package that imports text data into a SQL table. After the import I have a parameter query to update the imported data with a batch number. The query is set to ask for the batch number using "?" to create a "run time" parameter. The query runs fine in the "Data Transform...more >>

I am at wits end here. Package is set up to truncate 2 tables and load data from a Goldmine 5.0 .dbf database and copy that data to a sql 7 table. If I execute the package in SQL EM it runs perfectly. If I use dtsrun it works perfectly. If I use the dts pkg lib from within vb and execute it fai...more >>

PS if this is posted on google as well pardon duplication. Inside my ActiveX of my DTS package I am trying to scroll through my directory and based on FileExtension process or move file to archive. I want if the file is a dbf extension and not a i.dbf and d.dbf to process the file otherwise ...more >>

Darren, Thank you for aanswering the question that I send to Allan Mitchell. I have read many post, and I have try all of the different suggestions. With regards to your answer I have install these packages to my computer and to the server: sql2kasp3 SQL2KDeskSP3 sql2ksp3 I came across...more >>

I am trying to in activex script when looping through a directory if I come across a file that isnt equal to my .dbf I move the file to an archive directory. Not only must it not be a dbf file but it cant be a dbf filename that ends in i.dbf and d.dbf. gv_fileFullName = "c:\server\transfer\on...more >>

Hi there I am extracting data from an Access database into SQL Server tables, and then I want to send this data directly to a MS BizTalk Server Message Queue Receive Function without going via flat file. I am adding a Message Queue Task in the DTS-Designer, but the helpfiles are no help i...more >>

Hi Folks, This could be very simple problem, but I am having very hard time with this. I wrote a simple ASP script to run DTS package on IIS 5.0, it runs fine as long as the package do not have any Analysis Services Tasks such as for processing Dimensions or Cubes. In other words, if packag...more >>

I would like to know if we can store objects like Excel / Word / Scanned Image documents in SQL server 2000. Is it possible to store like in Oracle 9i etc. Thanks chitra...more >>

Hi Experts, I am designing a DTS script which should create an Excel page then it will run a SQL Query within it and paste the results in the Excel sheet. I know how to create the Excel Sheet with "CreateObject('Excel.Application") but dont know how to run the SQL Query within this Excel ...more >>

I do many distributed query from Ms Access & Ms SQL 2000, I already try link server, but performance is slow, My question are : 1. If I used DTS for perform distributed query, is performace better than link server ? 2. Does Ms Access support DTS object like vb ? Thanks...more >>

does anyone know how to refer to another connection from within an = execute sql task eg Execute sql task on connection 1 select * from authors where id not in (select * from = connection2.dbo.authors) Ive found you can use the standard databasename.tablename, but I am = developing in ...more >>

I have seen all of the articles and commnets that you have written specifcally the commnets realated to : System.InvalidCastException has ocurred at XXXXXX.exe Specifically in the code at: oCustomTask1 = oTask.CustomTask QueryInterface for interface DTS.CustomTask failed I install the SP...more >>

Getting the following error when running DTS from one of our Workstations to "Serverx" "The license for installation of Microsoft SQL Server on your Source and Destination connections does not permit the use of DTS to transform data. Refer to your License agreement for more information." ...more >>

I have a bunch of DTS packages, they run fine when I run them manually but when I run them scheduled via the SQL Server Agent they fail. The errors I am getting say they can't find the source file. I'm sure this is a permissions problem - but being new with DTS and not having any knowledge...more >>

I would like to use 'any character' plus a '\n' as a row delimiter when exporting a table to a text file. Problem is, DTS does not seem to allow a delimeter such as '||\n' as a row delimiter. I would like to modify the DTS defaults such as the '{CR}{LF}'. Have tried combinations such as '||{C...more >>

Im trying to refine a DTS package that I wrote. The question that I have is inside my dts package I have mulitple connections to different Tables within my one main database. I am trying to take my four Execute sql tasks and move them into one Execute Sql Task. Does it matter which existing c...more >>

I have a DTS package that loads text files. One of the file created by mainframe (Security.dat) sometimes has 0 bytes in it. While executing DTS Package, I need to check if the Security.dat file is 0 bytes. If it is, I need to leave the Security (Table that the data goes into)table alone....more >>

Hello, I need some information about transactions across multiple packages. Here's a hypothetical situation. I have a package (packageA) containing 2 tasks, both are "Execute Package" tasks. The first task executes a package called subpackageB and the second task (which only executes ...more >>

Package failed, error: x80040428, x80040000 + 1064 Package failed because Step 'Copy Data from Results to tb_vf_DAST_subtotal Step' failed. Step Copy Data from Results to tb_vf_DAST_subtotal Step failed, error: x8004043B, x80040000 + 1083 The task reported failure on execution. (Microsoft...more >>

Hi, I have a text file in which one field is a date but in file it is in '20030818' format and I am tring to import that file to a table which has a column datetime. is it possible to convert '20030818' to datetime during DTS import? if yes please let me know how ? Thanks. ...more >>

I would like to use DTS to read(loop) multiple TEXT files which have different record layouts. Inside the TEXT file there is a Header record and multiple Detail records. I need to Strip out of the Header record just one field(CustomerNumber), then when I read each of the Detail records ad...more >>

Hi! As I have 15 DTS Packages and the same connection in each, i'd like to find a process to change the password of the connections in one time. (rq : I'm using SQL Serveur authentification for a Microsoft OLE DB Connection) I don't want to save the password not masked, so it seems i can't us...more >>

Anyone, I normally work under Oracle, however I have a requirement to send a Sequel Database to a Oracle Client. I do not have online access to the Oracle database, so the DTS packages using OLE-DB etc cannot run. Is there any way of exporting the Database without a live connection ( I...more >>

Hi, Sorry to post the same kind of error as others may have done, but I can design and run a DTS from the SQL enteprise Manager GUI, but when I try to Schedule it or to see the version, the error is the following: SQL-DMo SQL State 42000, User (Null): not associated to a trusted SQL conn...more >>

I'm using Delphi to programmatically control/configure DTS packages, and I've noticed that in the unit where I'm using the DTS_TLB package, I can't seem to call on any of the TApplication stuff. For example, I can't do a messagebox nor an application.ProcessMessages. If I create another form,...more >>

I'm making a bunch of .dts jobs to move info between databases. I'm trying to keep the DB names soft, so they can be user configured. So far, with the Transform Data task, I've been able to use the Dynamic Properties task and reset the Initial Catalog on the source and dest connections. What...more >>

I am making use of Log Files and Exception Files in my DTS Package. How can I overwrite the file each run? Spencer...more >>

Hi : I have a package that contains 15 steps and 10 steps involved the error notification - sending email. I can not create just one send-email task that can be executed by the 10 steps due to the workflow condition is 'AND', not 'OR' - It means that all 10 steps have to fail before the send-...more >>

Does anyone know of a code sample or third party object to programmatically save a dts package to VB code like you can from the DTS Designer? I'd rathe rnot write my own scripter. Thanks, Steve Waldner ...more >>

Hi all, I am simply trying to implement an Execute Process Task through an ActiveX script. I'm able to control all the properties, but not the execute method to actually fire the event. Does anyone have an example of the execute method with its parameters? See below for the Script I ...more >>

I have an interesting situation: I have two DTS packages that affect the same table so if they run at the same time, we get deadlocks all over. I'd like to schedule each to check if the other is running an re-try 3 times after 1/2 an hour. So, add a new step in the schedule to do this and fail...more >>

I currently have an Access DB that stores 4 seperate modules that are ran through macros that for the most part clean up my file directory. Mostly deletes .tmp files and files that are no longer needed. We are now using SQL 2000 server as a backend DB. I have to run these manually onc...more >>

Hi there, I have a lot of DTS's that I have ineherited (and I am a bit new to this) where data is being moved from one server to another overnight. The DTS's are set up in the form where a DELETE FROM table script is ran, followed by the transformation of the data e.g. DELETE FROM Server2.T...more >>

Hi All, I've got the "Redistributing DTS with your program" (from: http://www.sqldts.com/default.aspx?6,105,225,0,1 - thanks Darren) printed out and in front of me. A couple of questions: 1. Is the ApplicationDirectory the root folder of "my" application? For example... "C:\Program Files...more >>

I created a dts package to import data from Oracle. when you click on the package and select execute everything works fine. Runs in less than a minute. when the schedule task starts, it shows executing, but never finishes. there is no entry for job history. How can I determine what is w...more >>