I would like to use transactions in dts without using dtc (firewall issues; no chance of reconfiguring). Is there a way to do this? I am only updating on one connection on a sql 2k database. thanks, ...more >>

hi Is there any way to changes the percentcomplete present in Onprogress event via the DTS designer ? teh percent complete always shows 0, how can it be changed to show the load progress ? kindly let me know....more >>

I am using 2005's DTS Beta 2 and am running into the error below when I execute my package: Error : AcquireConnection call to the connection manager <dbserver>.<db> failed with error code 0xC0202009. The odd thing is that I do NOT get the error if I run my package in Transaction "Supported"...more >>

I'm trying to create a dts package to load data from Informix to SQL. I created two connections - one for SQL and one for Informix (IBM OLEDB for Informix). I then chose the data transform task and clicked Informix as source and SQL as destination. But when I double click the connection lin...more >>

Set up a DTS package to import data into SQL Server from Excel. I would like an end user to execute the package, even right from Enterprise Manager, and specify the spreadsheet name and location at run-time. I would also like to allow them to browse for the spreadsheet, much like an ellipsis...more >>

I have a problem with a DTS package which needs to connect to a remote, ISP hosted SQL Server and backup the live data to backup databases on our local server. I have created the package on our SQL Server using Enterprise Manager on my workstation and when I run it it works fine. When I schedu...more >>

Hi all I am trying to import a text file with with a Fixed field length greater than 4096 characters. In the connection properties I am not able to set any position after 4096. Is this a real SQL Server limitation or is there somewhere a switch to set (maybe set to 8192)?? Thanks for any c...more >>

SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must use 'LOCAL' for the server name, not 'ASPEN'. Everything runs fine the first time, but later, when I try to execute, or even view, the local package I...more >>

Hi, Is there any differences in performance between DTS and T-SQL when copying tables from one db to another without any transforms? I'd like to keep everything as simple as possible, and doing a distributed query in T-SQL seems like the best option. Am I missing something, or is DTS totally ...more >>

I'm trying to make a DTS Import Transformation with the DTS Editor in Enterprise. My main problem right now is that I'm trying to import just a few columns from a table with several tables worth of information. So there's a tendancy for redundant data in the set that I'm working with. I keep ...more >>

Hello, I'm using SQL2000 and I have a table which has a field within it called "ImageFileName", what I would like to do is create a trigger to automatcially delete the disk resident image file that is contained within the "ImageFileName" field of the table upon the deletion of any of these...more >>

Hi All, I want to design a DTS Package that will read an EXCEL Document (One Data Source) and ONE SQL Server (2nd Data Source) and Execute one Query which will have a JOIN from Both the source and Export the result to another Excel Document. How Can I perform that using DTS? I have took ...more >>

I have a dts package which needs to branch depending on the existence of a certain text file. Currently I have an Activex VBscript step which returns Success if the file is found, and Failure if it is not found. I have established work-flow based on this. But when the Activex returns Failure...more >>

i am calling stored procedure in DTS i want to check on success or failure if stored proecedure failed i will send out email othrewise go to next step can any one help me to solve this proble...more >>

i am executing Following DECLARE @res int EXEC @res=Exec Admin_Fixes_Process_Duplicates_Referrals SELECT @res in Execute SQL Task My question, If @res value is not equal to 0 i have to make task failure else goto next task can any one give idea how to solve my problem, ...more >>

Hi All, I copied a package from server to another and now I can not open it on the test server...I get the following error: Invalid class string: any ideas? Thanks...M ...more >>

Is there any performance differences between the use of EXISTS and IN within queries?...more >>

I'm trying to create a DTS package that transfers a database (using Transfer Databases Task) from a remote SQL server to my local machine (the database doesn't exist on my local machine before the transfer), then runs a SQL script against the new local database using the Execute SQL Task. T...more >>

Hi, I need help in retrieving some data from our server which got deleted accidentally while exporting a stored procedure. What happened is I forgot to uncheck the "Export all dependednt object" while exporting the Sproc, and lost all the live data(It was overwritten by our local data). T...more >>

Hello all I have a small app that does some file exporting from an SQL server. On this SQL server a DTS package is run to draw in data from a dBase datasource. In the application I have written a routine that will run the DTS package on the server and report success or failure, the appl...more >>

Hello, I know that GetExecutionErrorInfo doesn't work when called from within a VB script. So I downloaded the zip file that the ActiveXHelper COM object from http://www.sqldts.com/redir.aspx?45, and registered the ActiveXHelper DLL as a COM object, but still can't get the function to w...more >>

Hi, Running DTS from VB is new to me, so apologies for the newbie question. I have a DTS package which runs problem free in MMC. I wanted to automate the execution using VB6. I've loaded the a Package2 object using the LoadFromSQLServer method (which works fine), but the Execute method fail...more >>

Does anyone know if there is a way to assign an owner and user password to an existing DTS Package without having to do a saveas and give it a new name. Thank you, Mike ...more >>

does nay one have a idea which tables r used by this sp...more >>

I am creating a global temporary table by calling a stored procedure in one of the steps in a DTS package. In another step, I am trying to fetch records from the global temporary table. I am getting some errors here. How to resolve this? Regards, Sevugan.C...more >>

Dear Sir/Madam, In a DTS connection on a SQL server say 'A", I am doing a select max(rec_id) as 'nextno' from table in a database resided in SQL server 'A'. I want to pass this 'nextno' to another DTS connection on a different SQL server say 'B' so I can do a select something from a tabl...more >>

I have some Global Variables i've defined within a DTS package that I want to pass into an ActiveX (VB Script) task within the same package. Anybody know how to do this? Thanks, Tom...more >>

I have a DTS Task that has the following: * Dynamic Property * SQL Task (Truncate a table in SQL) * Connection1 (Input CSV file) * Connection2 (Output SQL Server) This tasks previously did not contain a Dynamic Property and, as you know, the connection details and filename was hardcoded. ...more >>

I have encountered this situation a number of times and wanted to see if anyone else has run into it. I have a few packages that primarily call other packages they are kinda a loader package. I create this new "loader" package and add one or more "Execute Package Task" to the designer. As...more >>

I created a package on our dev server and can manually execute it OK from Enterprise Manager, but when I schedule it, the job fails. I'm having difficulty determining why this happens or where the error should appear. Are there common things I can check for, or settings I need to have in ...more >>

what i want to do is a follows: 1. schedule a DTS package with timeout.but should not terminate the job. 2. when it timesout i want to send out a alert that the job has timed out can anyone guide me on how to do this. thanks in advance kamal...more >>

I am importing data into a decimal field using sql 2000 dts. The issue I have is that if the first row of data is an integer and shows no decimal point or places (as this system seems to), sql then treats all subsequent rows as integers even if they do have decimals. There does not seem to b...more >>

hi, There're 11 subpackages in a main package.Every subpackage will first delete ( by executing a store procedure) sql server data and then transform data from INFORMIX to SQL SERVER. I use both DTSRUN /F .. and DTS /S ... to run the package and get an error, Step Error Source: Microsoft Data ...more >>

User needs to export the result set from a cube to an excel sheet. I was hoping to use DTS to accomplish this by adding a DTS execution command as a cube action and passing dim.curentmember as parameters 1.I needed help on how I could execute the package from a cube action. 2. How DTS can be ...more >>

Hi, I have checked the Source Error rows, Destination rows and Error checkboxes for the options of the data pump. However, on completion I only receive the error file. The file contains the following info... Error Source: Microsoft OLE DB Provider for SQL Server Error Description:Multiple-s...more >>

I originally created an SQL 2000 database from Access 2000. I stored the field descriptions in Access 2000 but they didn't transfer over during the DTS. How do I get these descriptions back into my SQL Server 2000 database? I've generated the script and have made some changes to the SQL d...more >>

I have been having difficulties for many months now when importing text data that is exported from SAP then FTP's from a UNIX server to my SQL server. What is happening is, when I use the text file source and data pump to import the data, I do not receive all the rows. I can take the s...more >>

Hi, Does any one have a link to some good DTS documentation templates. ? I am looking for a template to document my packages cheers, siaj...more >>

I have a situation where I'm loading text files into a database. Filenames are reused, so two files with the same name might hold different data. I need to be able to uniquely identify files using a method other than filename so that I know if I've loaded the file already or not. One though...more >>

Can I get high confidence that DTS packages (Saved as a *.DTS File) using SQL Server Enterprise Manager 2000 (Based Version 8.00.194) on Windows XP Service Pack 1 would run using SQL Server DTSRun.exe (Based Version 8.00.194) on Windows 2000 Server SP3, if I can confirm that the DTS packages w...more >>

I am trying to recreate the dialog that appears when you manually run a DTS package (DTS.Package2) in SQL Server 2000. To populate the list, I iterate through the Tasks collection and put each item's description in its own row. Only problem is that the Tasks are not in the same order that ...more >>

Does anyone know of a way to execute a job from a SQL Statement?...more >>

Hi, I have strange problem in that I'm exporting data into a text file - which works fine but it is generating an additional blank record at the end of the file. This file is being fed into another program which doesn't like additional line. I've tried changing the "row" delimiter but still have ...more >>

Hi guys I have a small problem. I want to use BCP with in a transaction it's this first I execute a SQL Statement against the database and delete some data, then I run the BCP utility. my problem is how to use these two with in a single transaction! please help me I appreciate you...more >>

Hi experts, Hope someone can guide me on this problem. I'm trying to import mytext1.txt into myDB table mytable1. During the import process I received this message:- Copy data from mytext to myDB.dbo.mytable1 step Error at Destination for Row 446109. Errors encountered so far in this tas...more >>