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 >>

I'm using an execute task to call the system stored procedure to execute an exe. Unfortunately, it gives an erro saying somethign about SELECT, UPDATE, DELETE etc... How should one execute an executeable using DTS, in an EXECUTE TASK or something else. Thanks. Mike...more >>

I'm trying to execute a DTS package from VB and would prefer to use a file DSN to connect to the database rather than code the connection info within VB. Does anyone know if this can actually be done though? I can run the package ok using objDTS.LoadFromSQLServer .... which requires the SQL...more >>

Not sure if this is a Commerce Server issue or DTS, but I have an exsiting DB which imports on a scheduled DTS package. Our servers had some down time and it missed a few days importing, I've pulled the weblogs off which were missed but when I start the import process I get a the followin...more >>

Hi I have a job using a flat file source I would like to launch the same job with every file of a directory! Could someone help thx...more >>

Hi What is the 0 (zero) in "On Error Goto 0" I found it in the microsoft site and I don't understand where it goes Could someone help thx...more >>

We have 2 servers SERVER1 & SERVER2 respectively. SERVER1 has the following tables as given below: Create Table Control( StoreID int, LastSuccessDate datetime ) INSERT INTO Control (StoreID,LastSuccessDate) VALUES (1, '2003-01-01') INSERT INTO Control (StoreID,LastSuccessDate) VALUES ...more >>

Hi Does anybody have experience with creating a button that executes a DTS on a MS SQL Server. The button must be created on a MS Data Access Page that is using the OWC (web components). I'm sure someone has done it before Jeroe ...more >>

I wrote a DTS package that includes connections to 2 computers: a server and a laptop. Then I call this DTS file in a VB6 program to do other things. I test my program, and it runs fine. Now, before I ship the laptop to a client, I would like to modify the DTS package to delete the connection to...more >>

I would like to use DTS to create a nicely formatted file that will be either emailed or faxed. What is the easiest way to have the output include white space for faxes? Any suggestions will be appreciated. Barb...more >>

I have inherited about 60 large DTS packages and now I have to find where a column name is used in all of them. Is there some metadata I can search to look for something when I do not know where it is? Thanks for any help Mike...more >>

Hi All, the following problem is giving me a little headache: a DTS package, which has run for quite some time automatically and quietly in the background, now massively logs errors (almost every 2nd run) to "sysdtspackagelog" in msdb. The package reads a textfile (Source) and writes a da...more >>

I have inherited maintaining about 70 large dts packages, and I am now looking for all instances of one coulmn name which gets used in many transformations. Normally I would use something like syscolumns in normal SQL, but cannot find anything similar. Is there a similar 'global' search mechan...more >>

I'm using the data pump to import txt data. In one column a carrage return exist in an unidentified position. Is there a was to remove this character during the transfomation?...more >>

I have a visual basic program that uses the DTSPackage Object Library to execute DTS packages. Is there a way to check to see if the file that is going to be imported exists other than then the ActiveX Script Task. I have been looking for a method in the Object Library that will do this fo...more >>

I am still very new to DTS and am apparently missing a few of the basics. I have a DTS package that runs twice daily. It works fine to add any new records from the source to the destination, however, it doesn't update any records that have been changed in the source. What additional set...more >>

Hi I have made a simple DTS that processes an OLAP job. THis DTS runs fine. As soon as I create a new DTS where I invoke the other DTS with the OLAP job it fails. It just stucks I do frequently apply sub-DTS whithin a main DTS and with normal SQL jobs it runs fine, but with Analysis Services it'...more >>

I wrote a routine in visual basic 6.0 that compacts an access database so that I can use DTS process to run the exe. When I try to run it I get this message, "features in this version are not available in databases with older formats ". The routine works, I know that for sure because I r...more >>

Hi, I am not sure why this error is occuring. This happens when i run the package as a job. The job succeeds 3 times and fails 3 times. The error message i get in the steo details while failing is, ----------------------------------------- Executed as user: xxx\yyy. DTSRun: Loading... ...more >>

Hi, I am not able to solve this problem. I keep getting this error and i do not have a clue as to why this is coming. Executed as user: xxx\yyy. DTSRun: Loading... Error: -2147467259 (80004005); Provider Error: 17 (11) \Error string: [DBNETLIB][ConnectionOpen (Connect())....more >>