I have created a DTS Package in SQL Server 2000 that imports a single file into a table in a local database. The file and path to the file are defined through GLOBALVARIABLES. When I execute this code in the DTS Designer it works fine however, when I instantiate the DTS Object Library I try t...more >>

Hi. I need to set up SQL Mail and then implement it to email an Excel File that I created within a DTS package. I've tried setting it up and no tutorials are helping. I follow it and I continuously get the error that Outlook needs to be set as the default mail and running, which are both true! I...more >>

I got a big Access file (1 400 tables) to convert to SQL and I would like to be provided with some automated tools, except upsizing wizard and DTS, to convert it on my own. I got a lot of forms and query to convert too. Can someday provide me with at least one tool name ? Thanks, Guy...more >>

Hi Allan, With your help I have successfully loaded a big text file into SQL database using your Article “Processing The Same Row More Than Once” (http://www.sqldts.com/default.aspx?266 I have one more question to ask you regarding to the DTS Speed The data I have in source has 10,000 rows...more >>

The current DTS i am creating sits on the SQL2000 server and picks up files dumped by our users into a specific directory and imports them into two tables. I have set a global Varaible in the DTS that flags if the DTS is already running. The DTS is set as a job in the SQL Server Agent to...more >>

I am using an execute SQL task to obtain a record from a table and export the parameters to DTSGlobalVariables as strings. The next Step in the DTS is to check that a record was returned. How can i check this as in EM the DTSGlobalVariables are returning <not displayable> ? thanks Sql2...more >>

Hello, I have an SQL server 7 on NT4SP6a. A DTS was created on this server. I want to save it to a file. But when I do it, I've got the following error : "Error Source : Microsoft Data Transformation Service (DTS) PAckage. Error Description : Access Denied". I checked the NT rights, the log...more >>

Hi there, One of our user had (and still has) the right to post DELETE commands to one of our main tables in the Database. I usually hate when managers has this kind of rights. Generate a lot of trouble. The scene is as following: he deleted some records from a very important table in...more >>

Hi I have a file with a row lenght of 350, of which 315 places are populated. When I do a preview of the file in DTS I see the correct row data BUT when I import into the database table it truncates the row to 270.... (the column length of the table is 450)... Is this a known issue, ...more >>

Hello All I'm developing some packages to be used generically between multiple projects, to handle file imports, and I'm creating a Controller/Worker pair of packages. I'd like the controller package to determine the directory path(s), and filename(s) of the files I want to get imported and I'd li...more >>

Hi, I'm new to this so please be gentle if I make a faux pas. I have a DTS script designed to run other DTS scripts in parallel, but its failing on the first script. I'm trying to run it from Enterprise Manager. The errors are logged as follows: Step 'Execute APOeWFM Load Incremental Meta...more >>

Hi Can anybody provide me with a link or an insight into how to tackle the following task. I have 2 tables of different structures with a one to many relationship and I wish to merge them into 1 text file. The output file would have Table1, Patient1, line1 followed underneath by Table 2 ...more >>

Hi there. I have a problem within DTS design. Out IT dept changed our server name without us knowing.. Great! I have run Sp_dropserver and sp_addserver to rename the server fine. However when I go into DTS i establish the server connection ok, but have problems when I try and build an exec...more >>

Hi, I have a database with a dot (actually 2 dots) in its name, lets call it [foo.bar]. Selecting this database as source or destination in the DTS Import/Export Wizard gives me an error-message when I select "copy tables and views": Server 'foo' could not be found in sysservers. Sel...more >>

I'm very new to DTS...this is the 2nd time I've used it. I have an Excel file that I want to use to UPDATE a sql server table. I'm walking through the DTS Import Data Wizard until I come to Column Mappings. My only options are to 1. create a destination table, 2. delete rows in destination table,...more >>

Hi Everyone. I need to create a DTS package that queries a table and sends the output to an Excel spreadsheet. I don't know enough about the way the tasks and connections in DTS work to make this happen. I already have my query that produces the right data but what do I do with it? :) In...more >>

Hi Everyone. I need to create a DTS package that queries a table and sends the output to an Excel spreadsheet. I don't know enough about the way the tasks and connections in DTS work to make this happen. I already have my query that produces the right data but what do I do with it? :) In...more >>

Weird situation on my SQL 2000 server: Trusted domain users can create scheduled jobs under SQL Server Agent. When the users execute jobs, the jobs get failed. The owner of these jobs have to be chenged to a local user of SQL server. Then trusted domain user can execute the jobs. I do no...more >>

can anyone give me an example of how to trap for an errors in and active x task if an error occours i want to execute a different step to the normal one how can i write an on error goto or on error do loop any one give any examples ...more >>

Hi all, I am performing an insert from a csv file into a table. For some reason when the data arrives there are spaces. He spaces are not apparent on the imported file. Has anyone else come across this? Many thanks Sam *** Sent via Developersdex http://www.developersde...more >>

I have an ActiveX opbject in one of my packages and when trying to run the DTS package by using the dtsrun command I get the results below. Is this a server configuration that I need to make? DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSActiveScriptTask_1 DTSRun...more >>

My DTS package worked before. But today it failed. From 'View Job history' I got the following error message: Error string: OLE DB provider 'SQLOLEDB' reported an error. Execution terminated by the provider because a resource limit was reached. Error source: Microsoft OLE DB Provid...more >>

I am trying to connect to a secured microsoft access db in the create a new DTS package program. I browse to the access db I want opened and I enter userid and password for the access database but I keep getting the following error: "The workgroup information file is missing or opened ...more >>

I'm reading the Timothy Peterson 'Microsoft SQL Server 2000 DTS' book, page 200 indicates that I can programmatically create Lookup Objects in an ActiveX Script I'm trying to do this in an ActiveX Script Task...ie. not a DDQ or transform task, and I can't seem to get it to work. Can this be done...more >>

Hi I am about to rebuild the master database. The DTS packages that are on the current system I intend to open up and save to another system, then rebuild and save them back to the existing system. Any problems with that or is there an easier way. Cheers Paul...more >>

I have read the articles that darren suggested from a previous post, but an still at a loss as how to get this scheduling working. We are running SQL2000 where user login using a user name and password. The DTS opens text files from a network directory on a different server, read the file...more >>

Friends, I'm going to run a dts package which transfers data from some tables in a local database to a hosted database over Internet. After transfering the data I need to perform some aggregation and so on. I'll set passwords on the dts package but will this security level be high enough be...more >>

Hi, I have a Database on one server and the same Database on another server. One Database has a DTS Package that I need. Can I export this DTS package to my Database that does not have it without doing a backup of the one that has it and restoring it to the one that does'nt? C ...more >>

When exporting data to Excel file, i always got a double entry on every data. Can anyone help ?...more >>

I am upgrading an old system that was written in Foxpro 2.5 for DOS. The tables have various date fields that include schedule dates and completion dates. Not all of the fields are populated. When I import these fields that do not conatin valid dates, SQL Server sets them to '12-30- 1899'. ...more >>

Hello, I have a DTS package that operates correctly from a VB module. I need to have two clients operate this Package on an as needed basis. The problem is that these clients don't have the dtspkg.dll library on their computer. I wrote an install program to register the library, but I d...more >>

I have developed a number of Packages that convert DBase 5 tables to SQL Server (using multi-phase datapump) for an upgrade of production systems from DOS to Windows. Recording Transform and Insert failures in the logs is necessary. If I allow Fast Load, in order to record the failures, I must se...more >>

"COM object with CLSID {10020200-EB1C-11CF-AE6E-00AA004A34D5} is either not valid or not registered." I created a package that imports data into sqlserver and exports data from sqlserver. When I run the package on a remote machine (remote from sqlserver) I get the error quoted above. What's ...more >>

Hello - I have three feeds from sources around the world, each coming in at a separate time. These feeds move into a large table (3GB) that is queried by managers. The feeds are loaded sequentially, and then the previous day's feed rows are deleted from the table (this is done so that the user'...more >>

DTS service is shown as running OK in Enterprise manager locally, but when I connect from a remote client the service is not available. Any ideas ? ...more >>

I'm trying to find a way to set the decimal places returned in an expression through a view, I've listed the SQL statement below. The two expressions I am looking at are the PagesHr and the BatchesHr, they are showing 12 decimal places and I would like the to show only 2. I've used the LEFT and...more >>

Hello, I have this situation: I have an Stored Procedure in my AS400. It has an IN parameter and = return a Result Set with 3 fields. I want to take this Result Set and save it in a table in my SQL. I did a DTS: .. Source : SQL Query in the AS400 : { CALL LIBRARY.NAMESP ( 'TEXT' ) } = a...more >>

I have one I need some assistance on using DTS global variables as parameters in a Data Transformation Task where the error message comes back as the data provider does not support parameters thanks...more >>

I need run a backup in my SQL 2000 that write in a remote disk. So, when I try this with TQL command BACKUP DATABASE this is very slow. I need some tips or tricks to run this. I someone can help, I thank's regards, Marcelo Roza mroza714@msn.com mroza714@ig.com.br ...more >>

Hi, I have inhereted a db with 550 tables & 1300 sps. 80-90% of this is a junk. I am looking into ways to clean up. Problem is, isn't clear which part is a junk :) I was thinking of creating some type of trigger and attaching to every object to update a table with a last access da...more >>

Was there ever a solution to this problem? I find these posts below but I don't find anything at MSDN or any solutions? I'd like to know if there was at least a work around. http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=UTF-8&frame=right&th=c349d5fe2b20f475&seekm=WyB3TkB1lqF7Ew90%40sqld...more >>

Hi I have some DTS packages whose owners are network IDs which have been removed from our domain. I cannot find a way to open them so I tried using the spDTSChangeOwner.sql script as described in http://www.sqldts.com/main.asp?nav=1,6,212, The displayed owner name changed however I was still not...more >>

We are having a rather odd problem with one of our DTS packages that creates a text file. The package is changing row delimiters between CR-LF and LF. We are not modifying the package but when the client attempts to import the file the delimiter changes. Anybody ever run into this behavior? Th...more >>

Hi there, I am new to SQL Server, we are running SQL Server 7 I am having some trouble with creating a delete query. Basically, i have developed a Access database that exports data to a .csv file, to be imported to SQL server via a scheduled DTS package. Most of the .csv files will only hav...more >>

Executed in a DTS package. Noting seems to happen when this code is executed as part of code below: 'Let user select a folder to export Set nms = xlOut.GetNamespace("MAPI") Set fld = nms.Folders(olFolderContacts) This is part of the code in the DTS: Set xlapp = CreateObject("Ex...more >>

I am wondering if there is any way to capture 'print' statements from a SP? We would like to be able to grab the debugging information that is being printed by the SP and use DTS to display it somehow, i.e. in a popup to the DTS admin who runs the packages. So... anyone know a way ...more >>

Hey All, I am trying to write a DTS that will import all the files in a particular folder to a Single Table. Say for instance i want to import everything in c:\Test (which is File1.txt, file2.txt), into a table named people. How would i go about doing that? I did it in access like this.....more >>

How do I change the DTS owner? Thanks. ...more >>

How to prepare ActiveX script, that convert data with "," to data with "." so it is properly written to column with money data type Or how to change settings of money type so it uses "," as a decimal sign?...more >>

I have developed a dts package that executes a datapump task against a list of destination servers. The package loops round and picks up the next destination server from a file and dynamically changes the datasource property of one of the connections. This works fine but now I need to add in an ...more >>

Hi I need to write a function fnCheckInputData(taskname ) which can be reused by multiple packages. This function will reside in package 1 Other packages consist of Data Driven Query tasks, I need to call above function fnCheckInputData(taskname) from activex script used in each DDQ My query: Is...more >>

hi, is dts able to specify partitioning schemes without changing business logic (separation of logical and physical)? Thanks...more >>

hi there, would like some help here. would anyone know if we can import data models from CASE tools? Do reply Thanks a milion...more >>

hi, i have a question on DTS,does DTS support distributed deployment (many servers with 1 metadata repository or many distributed servers with localized repositories). Thanks Jenny...more >>

Hello, How can I run a DTS package local on a client. Wich files do I have to install local? Thanks Francis Guffens ...more >>

on w2k I have a DTSpackage with one ActiveX script in it, for some reason it just sites thier with the arrow going through the cogs, and will not cancel, I have to Ctrl Alt Del to kill it. If I run he vbsscript from the cms prompt it works as expected, And If i execute the ActiveX script it w...more >>

I have an ASP page that calls a DTS package (SQL 2kSP3). It runs fine when run from a member server (IIS 6) on the AD domain. When I run it from a Workgroup Web Server (IIS 6) it does not run, I get the following: How can I run the DTS package successfully from the Workgroup Web Server? Thanks, ...more >>

I have created a Windows NT account that I wish to use to establish a DTS Connection as I am requied to use a Windows Authenticated account. Simple enough, except that the account that I am creating the DTS job in DTS designer is not the account that I wish to use as the Windows Connecti...more >>