I've a job that needs to download a table from Oracle, which table name is stored in an Oracle table. I can use dynamic sql in Oracle, so it can have the same name every time, which needs a lot of space and sounds very stupid. Is there a better way of doing it? Thanks in advance for your help ...more >>

Hi, I have a query regarding customization of data transformation using DTS. I have created a table in SQL Server 2000, in which data have to be imported from an excel file. I have a folder containing number of excel files. The problem is that, i have to import only that file which has ...more >>

Hi Allan 1)Is there any site which would explain the Process of Extract Transform Load in a detailed manner? 2)Is ETL A part of datawarehousing ?if so how? 3)How well does DTS Support the concept of ETL is there any documentation on DTS Support for ETL Thanks in advance Sunny...more >>

Hi all Does anyone have an example (or a product) that they use to automatically FTP a text file to an FTP site through DTS (even if its a batch process? As far as I know, the DTS FTP Task only does pulls, no pushes Thanks Mark...more >>

I have two computers with Win 2003 Server, both have SQL Server 2000 with service pack 3a. I made a local DTS package using the export data wizard that transfers all data and objects from a database on the primary server to a backup server. With the first scheduled execution of this packa...more >>

I want to build ActiveX script task inside a DTS, that will change the file name of the Destination file to something that is inside the Source file!!! for example: convert CSV(text by delimiters) to EXCEL the CSV file will look like this: test.xls 1,2,3 4,5,6 at the end of the DTS i wi...more >>

I have upgraded 2000 server to 2003 and now all DTS functions stopped working I get the following erro Application popup: mmc.exe - Entry Point Not Found : The procedure entry point GetTextExtentPointI could not be located in the dynamic link library MSDART.DLL. I have updated to MDAC 2.8 still...more >>

We are receiving the "Invalid Class String" Exception when trying to execute our package from a VB.Net application running on a client computer that was not used for developmen or anything else to do with SQL/VB.Net/etc. It is a "normal" environment where our user will running the application ...more >>

Good day Scenario ---------- DbServer (DTS packages) <--- AppServer (C# application - Only Windows Authentication allowe - Duplicate Windows user on both machine What are the minimum permissions that I need to set on the user (on DbServer box) to enable this scenario? (i.e. enable public for...more >>

Hi, I need to create a script that will insert a subset of the records in a table into another copy of the table on a remote system. I do not have access to the remote system via Enterprise Manager. Rather, I need to email the script and have an operator execute the script in Query Analyzer....more >>

hi, i'm working on a project need to update the sql by using the mdb files. one of the tasks is modify the member ID since there will be a chance for member to replace their membership card (my project is a kinda membership system). in my case, there will be a mdb file storing the new member id ...more >>

Here's what I need to do. I have several MS Excel templates that I want to create a copy of, then put the file in a working directory and push data to several worksheets inside the Excel files using DTS, then I'd like to move the file to an FTP server. I have one particular task that I'm not sure...more >>

This is weird. I wrote a simple DTS package to copy a server Database to a laptop database. The program runs fine, but after probably 1 hour of running (this is a big db), it fails with the message: ALTER TABLE statement conflicted with COLUMN FOREIGN KEY constraint 'FK_Parcel Item Image_Ima...more >>

I am loading the package from SSF. I set all steps to EXECUTE IN THE MAIN THREAD. I see lots of posts this is necessary with VB6, but do I need to do this with VB.NET? I tried using EVENTS. This is really strange. I get the same event refiring repeatedly, with the same event parameter data. Perh...more >>

Hi all, Sql server 7.0 I am using web assistant job to display some data on web page which refreshes every 1 min. the jobs running fine but when i checked event viewer of application logs, i found the below error Error: 16821, Severity: 16, State: 1 2004-02-27 07:37:02.70 ods . Oper...more >>

Is there an easy way to export to PDF in DTS SQL 2000 Need a data connection for PDF? Any thoughts on something simple Thanks for any thoughts in advance Gary...more >>

How do i transfer a DTS package to another SQL server. I have a SQL 2K SP3 running on WIN 2K SP4. Thanks for your kind help. Regards ...more >>

I have an application which is networked based, but allows a local version to be depolyed. The local version would use MSDE. The application needs to run a scheduled job on the local machine to update diary entries for data cahnge while the user is using it in local mode. I have looked...more >>

Gday guys, I am having a problem invoking a DTS packade on my SQL Server. I am using the stored procedures that use the OLE object to invoke the DTS package. The package I am using is available 'http://www.databasejournal.com/features/mssql/article.php/10894_1459181_1' called 'spExecutePKG'. ...more >>

Here is what my DTS Package does: 1. Extract records from a SQL Server DB and store in a recordset. 2. Write recordset contents to text file located on a network drive. 3. Run macro utilizing above text file as input. The package works great when I manually execute it. When I schedule the...more >>

This is a pretty trivial problem, but I don't want the log file to be confusing when an operator reads it I created one DTS package to import one file, then opened/saved as a different package in order to clone the package. I changed all of the properties in each package. But when they run, they...more >>

hi all !!! the most common reason for DDQ failure I suffer are duplicate key in inserts. I wonder what's the best way to handle this errors within the transformations. what I would do is: for each record to insert, run a lookup query to check if exists if doesn't exist, do an DT...more >>

I am trying to import some files located in an AS/400 library. I use Mochasoft to connect my Windows 2000 Server to the AS/400 library through a ODBC connection. The ODBC connection works fine. I use it from MS Access to import the AS/400 tables and the import job works fine. When I use ...more >>

Hi I know that this is possible, because I've done it before... actuallly it was about two years ago when I came up the the solution on this newsgroup.. So hopefully there's someone out there with better memory. This is what I need I want to load all the excel files found in a particular dir...more >>

I've noticed during transformation that my Access autonumber primary keys are changed to int types as default. Is there a better choice? ...more >>

I have several DTS packages that are grabbing data from a BTrieve data source. When the data source was on the local server as a test source, everything worked fine, both scheduling and the package itself. But when I re-pointed my ODBC driver to a mapped drive on our network, to a server with the ...more >>

We are using DTS to copy from Oracle Views to SQL server tables. One Oracle column is Long data type and contains text in rtf format. When transformed to a SQL Server 2000 text field the data is truncated to 100 characters long. Have recreated this transformation with the same results. I w...more >>

Hi, I hope someone can help me out with this matter. I am trying to implement a DW Solution for an Organization. I need to clarify the following points. (1)is there a provider for Progress so that i could connect to progress database in order to import the Data through DTS?Are all ...more >>

Hi, I need to export data from several (100+) tables in a non-SQL Server database to a CSV file and I would ideally like to do this with just one dynamically modified DTS package. In the past I have used BCP and altered the various parameters when exporting from SQL Server. However, BCP is not...more >>

We have an application that utilizes a dozen or so (and will be more) DTS Packages The major issue we have is that although we take advantage of the INI file configuration we are "forced" into hard-coded the location of the INI file. Is it possible to have thi be set dynamically as well? Our cl...more >>

Hello, I would like to have a DTS package read Global Variables that are stored in a app.config (XML) file located on a network share. What is the best way to accomplish this? I have tried writing an extended stored procedure in VC++ 7 to return a value based on a key as an input parameter, ...more >>

i try to do something very simple : export data from an sql query to a text file It works fine when i export a table, but doesn't work when data comes from a view/sp/query, the DTS designer don't create the appropriate column when i clik on "execute" and when i click on the "define colums" but...more >>

My client requirement is to have an exported text file with specific fields widths ( these do not match the column widths ). eg column1 50 column2 25 column3 40 etc etc. I have written an ActiveX transformation that takes the 50 columns of data and outputs it to 1 destinati...more >>

If I right-click on msxml2.dll I see version 8.3xxx What's up with the versioing? I have a test script that says... ''' If MSXML 4.0 is not installed this will not work! Set oDom = CreateObject("Msxml2.DOMDocument.4.0") TIA JeffP.... ...more >>

I've been working with csv files as linked servers.... I'm starting to explore XML and was wondering if there is a way to apply the schema to enable an XML document to be a linked server? TIA JeffP..... ...more >>

I have a data migration package that pulls data from DBF files located in different folders on disk and loads the data into a single SQL table. The package is called from another package containing an ActiveX Script which sets Global Variables that tell the called package where the next DBF file ...more >>

Hi, I was trying to open a crystal report through DTS and this is the code I am trying to execute: Function Main() Dim lCrystalApp Set lCrystalApp = CreateObject("CRAXDRT") Main = DTSTaskExecResult_Success End Function I am getting the following error: ActiveX Compone...more >>

I have been given the task of slightly modifying a DTS package but know absolutely nothing about DTS. I have been able to copy it from one server to another where I am to use the new package. I have also been able to edit the connections and Execute SQL tasks, but the main 4 transform da...more >>

Hello I created a Linked server to access a secured Access Database. According to SQL Server Help file I configured (using the Registry Editor) the Windows Registry I have add the full path name of the Workgroup Information file Used by my Access Database => in the line HKEY_LOCAL_MACHINE...more >>

Here's the explanation. My DTS process uses a text file to populate a sql server table and an access table. It works fine before adding the CompactDB step. I wrote a VB program that compacts a database using the Jet method compactdatabase. It works great when ran alone on the command l...more >>

Hi I would like to use a global variable to initialize the file name file of a source text file box Can someone help thanks...more >>

In a class I took there were some warnings given about creating a DTS package in a test environment and then moving it to a production environment. Sadly, I can't find my notes anymore! :-( Does anyone know the subtleties of doing this migration? I have a client I'm going to tomorrow who is ...more >>

is it possible? could anyone give sample code for ActiveX Script Task? ...more >>

hi all !!! my destination database does not support parameters (?) at the insert queries. so for each record I dynamically build a new insert query, customized with the data to insert. the problem is that although the new insert query is created, DTS doesn't use it. It uses the SQL inser...more >>

I'm writing a utility, in VB6, to create a new database for non-dba's (mustn't give those developer's too many rights). I create a new database using SQLDMO and then give the user the choice of creating the appropriate table structure (for use with one of their utilities) from a script, or copyi...more >>

hello. i need execute from an execute sql task the following: delete discoinv_dbt from oinvoice_dbt inner join discoinv_dbt on Dprt = Numb_Dprt and Invoice = Numb_Invoice where Date >= ? when i check syntax dts designer shows error: Invalid column name: 'Date' but this sql w...more >>

I have created a DTS package with an Send Mail Task at the end. All task complete successfully when the DTS package is ran manually. However when the package is scheduled all complete with the exception of the Send Mail Task. The error is "MapiLogonEx Failed due to MAPI error 273". SQL M...more >>

Hi, I am trying to run a package that calls a series of java classes within oracle 9i on windows 2000. There are two parameters passed in, two paths on a windows 2000 machine. I have set permissions to these paths as follows: exec dbms_java.grant_permission ( 'AVENTISDM', 'SYS:jav...more >>

Dear DTS experts, Using DTS data to load data from CSV, I can skip first line (such as title). My CSV file contains a foot that I want to skip. Can DTS skip the last line of the text file (CSV file). thanks! Dan...more >>

Hi, I have a quick question on DTS. I have a number of packages that scan a directory for files, txt, csv, and xsl. Each fiel type is in it own folder, like c:\new_xsl, C:\new_csv and C:\new_txt. There is a different package doing the transformation for each file type. The problem th...more >>