Hey guys, I encountered a problem recently while working in DTS. I am trying to connect to a remote SQL Server over network. What I did is as below: 1. In "SQL Server Client Network Utility", and in Alias tab I created a server alias with remote SQL Server IP address and port con...more >>

Can you provide suggestions of how to troubleshoot a DTS Package that when I launch it runs sucessfully but when it is launched from a scheduled job it fails. This package is a very simple one that clears a table, then copies data from an Oracle view into the table cleared in the previous ste...more >>

Hi, I have Windows Server 2003 Enterprise and SQL 2000, when i executed my DTS package i receive this error: Beginning of Package Transaction failed when executing Step 'DTSStep_DTSDataPumpTask_1'.A connection with the transaction manager was lost. Whitin the Package Properties I use ...more >>

I have a DTS package which copies rows from 150 tables using Union ALL. Around 30 million rows are involved. However package fails after 8.6 million ros with the error Error at Source for Row number 8697091. Cannot convert nvarchar value of (NULL) to tinyint. Errors encountered so far in this...more >>

I have a DTS package. The select for one of the transform data tasks look like: SELECT * FROM UDF1('1/1/2005','12/31/2009') right now the dates are hard coded. Is there a way to pass parameters to the DTS package to change the dates? Can I use DTS global variables? Any other ideas ...more >>

I have developed a DTS package. The package consists of several active X script tasks, and several transform data tasks. When all the task suceed, it works great. However, If I return _failure from one of the active X scripts, execution stops. The failure workflow path in NOT followed. ...more >>

We have 2 jobs which will call the different procedures,this procedures will call different DTS Packages.These packages will get the data from LOTUS NOTES database.From the past 10 days we are getting an error DTSRUN.EXE-APPLICATION ERROR.THE MEMORY CANNOT BE READ....more >>

I am trying to use an ActiveX script in DTS to copy a file from one drive to another. Both drives are on the same server as my instance of SQL2000. No matter how I run the script (Enterprise Manager, or job) from either my workstation or logged on to the server, I get the same error: Error...more >>

I was wondering if it is possible to do something like this: Dim ColName = "username" Dim SomeVar SomeVar = DTSSource(ColName) Does anyone know if it is? Thanks in advance for your help. ...more >>

Hi All, We have a task of generating flat files (.dat) with bcp native fromat by using DTS. we have OLTP tables, by applying business rules we have to create flat files, which are suppose to be in bcp native format. Can any one suggest how can we do this. ? Many thanks. Soma...more >>

I have created a DTS package that is made up of one ActiveX script that opens a .NET web page and generates a variety of reports, converts them to PDF and copies them to certain locations in our network. If I execute this DTS package manually everything works perfectly. Although when I go to sc...more >>

In my scenario, I have a VB.NET class that runs a DTS package. This code has worked for years, but under heavy stress I am seemingly running out of connections from the connection pool. This leads me to believe that the connections being used by the DTS package are not being freed up properly ...more >>

I am trying to import data from a excel sheet, for that created a DTS package and running the package through a scheduler. Initailly the file got 3 records and alter added 5 more rows to the sheet. Every time scheduler runs and populating old 3 records only and I am not seeing the new 5 row...more >>

I try to export a table with 86 columns to a coma delimited file but when trying to define the destination columns in the Transform Data Task Properties dialog box when clicking on define columns button SQL server crash a close immediatly. Why does this operation crash and how is it possible to ...more >>

I try to save a simple data transform task from a table to a file to Meta Data services but this option is not available . I can only save to :SQL Server, Visual Basic File or Stuctured Storage File. Why is this option not available? Thank you in advance for any help on the subject Eric ...more >>

SQL 2k sp4 As part of a DTS package, I want to use the name of the currently logged on Windows user to populate a UserName field in my table. Can anyone tell me how I can do this - get the name of the currently logged on user? I'm figuring it can be done in an ActiveX step but don't know ...more >>

Hi, Now I am using multiple Data Transform Task to BULK INSERT to the same destination table at the same time. The aim is to boost performance and I found it pretty good. Do you know if there is any risk in doing that? Thanks in advance James...more >>

Hello all: I have an ActiveX Script Task that runs some code and builds an ADOR.RecordSet object and then assigns it to a global variable. The recordset is used through the rest of the package (its a loop). What I'd like to know is "Do I have to deallocate this global variable recordset o...more >>

This is probably a common problem, but I failed to find the answer on the Internet. I am trying to import the Excel-formatted (rounded to 1 decimal place) value of a number in a Worksheet into a decimal column. When it imports, I get the unrounded value. How do I tell DTS to import the rounde...more >>

I am attempting to run a DTS package from a SQL script. When I run this: EXEC master.dbo.xp_cmdshell 'DTSRun.exe /S <mylocalserver> /E /N "PM DWH Master" /A @RunDate:7=10/10/2005' I get this error: Error string: Login failed for user '(null)'. Reason: Not associated with a trusted SQL...more >>

Hi, I'm trying to create a simple DTS package in SQL Server 2000 using Enterprise Manager .... I've 2 DB connections and multiple Transform Data Tasks (i.e. gray arrows) between them. I was wondering how I can control the order of the Transform Data Tasks (i.e. to have Transform Data T...more >>

I just started a position where a person at this company submits file pulls from different sql server 2000 databases in lots of ways. This person does not have anything setup in steps like using a dts package. Thus I have the following questions about setting up DTS packages: 1. Can a dts p...more >>

We have a DTS package (VBScript) that contains an iterative loop. Within this loop, it will instantiate a DLL (VB6), call a method on this DLL and then set the instance to nothing. Within the DLL I have studiously tidied up all the in-memory objects; disconnected recordsets are closed and ...more >>

i I have set up a DTS job that pulls data from an Oracle Database It has worked for more than a year using the Oracle 8i Clients and and the Microsoft OLE DB Provider for Oracle. I installed the Oracle 9i Client and tested the DTS and it worked. I then removed the Oracle 8i Client and test ...more >>

I am trying to export data to an Excel named range via DTS. I have the data transfering but all data is transfering to my empty named range as text. I have formatted the area in excel as numeric before hand, but it still transfers as text. I have seen several references to this problem on...more >>

Re-post from Jan 20, 4:27 pm - still can't fix it!! Hi, When i execute the same DTS job on another server not running SQL Server I get the following errors. But if i run the job on the same server as the SQL Server it works. Or if the DTS transactions are turned off it works. Both ser...more >>

How do i save a .bas file to SQL server DTS package? I have already tried porting the bas file code to dot net and used SQLToSave. all that works fine. What i want to know, is there a tool available that can save a .bas file to SQL server DTS packages?...more >>

Dear all, Appreciate if anyone can share experience on connecting directly to Lotus 1-2-3 files through DTS. Currently I am using SQL Server 2000, and would like to connect to *.123 files (Lotus SmartSuite 9.8). Thanks in advance. ...more >>

In this post I am going to try to simply a question that I posted earlier. Can I use VFP to access a SQL Database? If so what is the command? What is the best software for creating applications to work with SQL? I am just getting my feet wet with SQL so please take it easy on a rookie. ...more >>

Is it possible to import tables from an Access database which has been secured with a unique Workgroup file (as described in the Access Security FAQ)? I tried doing an import against the table and supplied my username and password. However, DTS returned the error ".......the workgroup info...more >>

I have designed and scheduled running of a very simple sql 2000 DTS package. Out of my years of experience, I have not encounter this problem before. However if you know, you must be an expert! Well... I am trying to schedule a job to run during off peak hours to copy 13 million records ...more >>

The original table has dublicate information because it was not properly normalized. There can be several different primary key values for the same item. For example: 1 GoodBookTitle 2 GoodBookTitle 3 PracticalBookTitle 4 GoodBookTitle 5 PracticalBookTitle 6 OkBookTitle I l...more >>

Have a DTS package that will run on the server and through a job scheduled on the server. But when attempting to run it from a remote machine or an ASP page it fails. On the ASP page I'm using objDTSPackage.LoadFromSQLServer "Supersix3", "DTSexec", "DTSexec", DTSSQLStgFlag_Default, "", "",...more >>

We need to create a DTS script to push data from one sql server to another on a scheduled basis, changing some column names in the process (we do not want to do replication). I start creating the DTS script and click on copy tables and views and SQL server gives an error message about a server ca...more >>

I have some jobs that just started failing. They were working fine and then they just stopped. Nothing was changed. This has happened before and then they just started working again. Can anybody tell me why this happens. The jobs execute DTS packages that import data from text files and other ...more >>

I'm executing a store procedure in the source tab of a data pump task, the real problem is that the source server is a Sybase ADS 12.5.3, I was using a sybase 11.9 and when I select the transformation tab the source columns apears, but now they don't. So the Task returns error. Can Anybody h...more >>

I would like to be able to read an Excel file and loop through all the sheet names until I find the one I want. I suspect there is a way to do this but I can't find it! thanks, Michael...more >>

Today I faced a weired problem. I have a DTS package which is scheduled daily, generally it takes around 15 minutes to get fresh data. Due to some problem we had to clear the tables and start all over again. I have done it previously and the DTS took around 4.5 hrs to complete for around 5800...more >>

HI All, I am updating a DTS package created by smeone else. There is a table used in where condition. I need to find out how this table is populated. There are 650 DTs packages and searching all of them for finding this table is tedious job. can neone suggest a better method? thanks...more >>