Is it possable to update a Global variable in another DTS package that is to run later from a stored procedure that is running in a package now Thank you...more >>

The DTS task imports 5 dBaseIV .dbf files across the network to SQL2000 running on a SBS2003 server. The files are set (by the transform tool) to delete the old records in the matching SQL table and import the new records. This DTS was created in a terminal services session on a XP client using...more >>

Currently I am loading a table by reading a flat file. Since I am loading more than 5 million records it is taking some time to load the data. I am using DTS package to read the data. Is there any alternative(other than DTs package) to read the data from flat file and to load the data into the t...more >>

I NEED TO DEVELOP A DTS TO READ SUBJECT FROM ALL MESSAGES FROM A SPECIFIC EXCHANGE INBOX, AND IF POSSIBLE MARK AS READED. HOW CAN I DO THAT? THANKS -- Message posted via http://www.sqlmonster.com...more >>

I am trying to use DTS in my VB6 app, but cannot figure out what files are required for my set up program. DTS in my VB6 works on my machine with SQL Server, but I want to run it on another comptuer. I am using Install shield to create a setup program, but when I run the program I get an err...more >>

Hi: I have a DTS that connect to an Oracle database and transform the data into SQL Server tables and I'm trying to creat an ASP page in a web server to run this DTS. I tested this DTS in my computer through the Enterprise Manager, and it works fine (I have the Oracle Client installed), but...more >>

Hi all I've tried about everything. My problem is that I have this .asp page that executes a DTS Package, this package gets some data from a table, saves it into a text file. No problem so far. Now I would like to move the file from my server to another server = FAIL!!! Wher i run the DTS Pa...more >>

Is there a way to set a destination text file to be appened to rather than overwritten? I have looked through the disconnected properties and cannot find how to set it to append rather than overwrite....more >>

Hello, I'm new to DTS and have been learning as much about it as I can. I have about 20 DTS packages at work that simply reads a .csv file and imports the data into its own table. The problem is, I'm going to have to change the path/filename and resave the package each time someone wants to ...more >>

Does anyone know of any good DTS sites that have sample DTS packages for common or specialized use? I've been to sqldts.com and that seems to be the best site I've found. Also, anyone have any good books/sites to recommend for coding DTS from VB6? ...more >>

I'm wondering if there are any other programmers/DBA's out there that have lots of databases that they need to routinely monitor its file growth over time. I'm looking for any VB code or scripts that accomplish this. We have about 500 SQL Server databases on one of our servers and they exten...more >>

I have a dts pagkage on a development server. How do I move it to a production server when linked servers are disallowed?...more >>

Using a sql server connection to text file transfer, I want to end each row with a Pipe CHR(124), carriage return CHR(13), and a line feed CHR(10). How do I do that? I'm doing the package with the GUI....more >>

I have several DTS packages scheduled as jobs in SQL Server Agent. All the DTS packages execute flawlessly when run manually. When run through the job subsystem, the DTS packages execute, but packages in which the final step is to FTP the results to another server will hang on that final step....more >>

I'm trying to use DTS to upload data via a query statement. The PK is an identity column. I tried running the query without saying anything about the PK, thinking it would supply those values (like MS Access does for me) but it failed because those were left null. What should I do to import my...more >>

Does anyone know how can I use DTS global variables in DTS SQL statement? Thanks a lot. ...more >>

I received from DTS File and related Excel Sheet from my customer. I could be able to open the DTS File. It showd a connection between Excel and OLE DB Data Sources. Then I treied to run this , it says ' Trasform Data Task:Undefined ' Kindly let me know the procedure to run Am totallay ...more >>

I'm trying to pull files from an ftp site. Part of the file name is the current date. I have put together an Active X script task to generate the file name, but cannot get the dynamic properties task to use the generated file name. I read that following the file name with 3 semi-colons (;;;...more >>

Hi, I've been trying to get bulk insert to work and have this statement bulk insert dbo.myTable from 'c:\test.csv' with (datafiletype='char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n') I'm trying to get this to work in the SQL query analyzer. But i see that it is trying to find this file ...more >>

The script is exactly the same, but doesn't work as part of a DTS package. -- ************** -- ************** SETUP TEMP TABLES -- ************** declare @logsize real declare @logspaceused real if exists (select * from tempdb..sysobjects where id = object_id(N'[tempdb]..[#tmp_sfs]')) ...more >>

Is it possible to execute a cursor in DTS package? HOW? Thanks in advance!! ...more >>

I have set up a loop in DTS which connects to various servers and collects data from them. I have two parameters which are fed into my transform data task query from global variables. EXECUTE uspGetAlertPool @LastRun=?,@ServerID=? For some reason, the LastRun is not updated every time it l...more >>

I'm using SQL DTS to import data from files with dynamic names into a SQL table but I'm stuck at STEP 7 of the batch file.(as in the link) http://www.databasejournal.com/features/mssql/article.php/10894_3325731_1 I'm saving my DTS package as a Structured Storage File. I'm able to capture t...more >>

Does anyone know if there is max number of records DTS will import into a table. I'm getting an error saying there are too many delimeters in a record but that record looks fine to me. I'm wondering if this error is just a generic one and really means something else?? Thanks!...more >>

I'm fairly new to DTS. I'm running a Dts where the source and the destination are Oracle databases. I need to run some Sql statements to create temporary tables and proper indexes before doing any more complex stuff. When trying to run those statements in an Sql Task, it seems that i'm only ab...more >>

I having problems with the following scenario. (1) When I run a DTS package that processes a cube it works fine. (2) When however I run this package from within another package it just hangs, i.e. starts but nothing happens. Both packages run under the same Windows authorisation which is ...more >>

Hello, I'm trying to import a text file with fixed width fields. I've noticed the following problem regarding this: Let's say I have four fields in my text file. When field4 is blank, i.e. there is a {CR}{LF} after field3 the import process does not mark field4 as null. Instead it goes to the...more >>

Wonder if there is any way that I can put up my microsoft files into the website? And have it design as whenever I save the latest edited files it will be captured on the specific website as well?...more >>

Hi Friends, I have a SQLServer Job that try to execute a command DTSrun using the proc xp_cmdshell, but I receive "Access Denied" when the DTSrun are executed my configuration: SQL Server 7.00 - 7.00.1063 (Intel X86) - SP4 Windows 2000 - Service Pack 4 Someone can help me ? thx Jo...more >>

How to populate a global variable by reading the data from a database. Basically I want to find out the max date from a field and poulate the variable. SQL2K. Thanks Brian ...more >>

Hi all I have a Windows Server 2003 Web Edition running. No i have one problem...I can't install the Enterprise Manager on the Web Edition of Windows Server 2003. How can i still get a DTS running on a SQL 2000 MSDE Version? how can i copy it or move it over to that machine? thanks for y...more >>

I have a DTS Job that is scheduled to run daily on our SQL Server 2000 server. Is there an easy way for me to determine if the DTS job ran successfully? Does DTS provide anything for this or must I use DMO to look at the jobs collection? ...more >>

Hello all! I've created a custom DTS task in the .NET Framework 1.1 and have it installed and partially working on the server it will be residing on. If I log into the machine using my account and manually open and run the package, everything works. If I log in and use the limited SQL Ser...more >>

I run several DTS packages each day, I would like to convert from an e-mail based export system where I save the exported file locally to the server, then pick it up as an attachment and email it to a system where I export the data file to a network share location. The issue I am having is ...more >>

Hello All I want to create a export of a given table as a .xml file with a .xsd Can somebody please point me in the right direction how I can do it. Also, once I have created a .xml and .xsd how do I import the table structure and contents after having dropped the table to recreate it fro...more >>

Problem at hand: Moving / Migrating jobs from development to test to production. Current situation: SQL servers are instances in many cases and not necessarily "local". A "common" SQL database is used to store connection information that is read using dynamic properties task to modify the S...more >>

I needed to run a conditional SQL that include a value from a global variable set prior to the task. For some reason, the conditional (IF) and the global variable couldn't work together. One or the other by itself is OK. Below are the SQL I am using: Case 1 works (with IF): IF ((SELECT ...more >>

SQL 2K - DTS I got a packge to load from Excel sheet to database table. This Excel file got many sheets and I have to just read from one of the sheet BUT it is hidden. Any links or tips for a VB script to create a name range for one of the sheet. Thanks Jeff ...more >>

There is a sql task in a dts package that runs a stored procedure which fails on a primary key constraint while inserting a duplicate row. If the package is run from the dts designer, it reports an error and follows the 'on failure' path. If the package is run with the dtsrun command fro...more >>

I'm fairly sure this question falls in the "DTS 101" category, so forgive me if it's as basic as they come....I have a source and destination table, each with the same schema. I'd like to copy the contents of the source into the destination, overwriting those destination records with matchi...more >>

I have a nice DTS extract from SQL to Excel setup where I pull the data and load into a spreadsheet. I then have a SendMailTask which mails the result set in Excel to a maillist. My Problem: Somehow, in setting schedules I get duplicates of the Excel file attached in the e-mail. I've act...more >>

Hello: Simple question from a relative DTS newbie. When a DTS package is running, I want to make sure that the only thing that can update the tables is the package, and that the package cannot be run by anyone else while that instance of the package is running. What is the best setting for t...more >>

This is from a Microsoft FAQ from July: http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnsql90/html/dtsfss05df.asp [CLIP] Q. Why Aren't Global Variables Available in the ActiveX Script Task? A. Access to global variables is not supported in Beta 2. Are Global Variables g...more >>

Hi! Whenever I create a transform data task which transforms data to and/or from an Oracle database, it takes a very long time for the properties dialog to appear when I right-click and select properties on the task - ranging from 15 to 40 minutes. Any ideas what this could be? It naturally...more >>

I have a txt file that contains the date in a string format. I import this in directly and it comes up a vchar instead of a date field. I need to convert it to a date so I can do an index on it. I don't know if it is possible to do in the DTS or if I should leave it how it is and then use a co...more >>

We have several jobs that run DTS packages. Yesterday our IT department changed all users network IDs. The owner of the jobs was able to change the ownership of the jobs to his new ID but it doesn't look like he did on the DTS packages. All of the jobs failed because of this. Is there a...more >>

Hi: I have a DTS package that first brings in data from another database into SQL Server. In the source database, the database tables are like this: TableName20041014 for example. At any one time, 10 of these tables are in the source database, every day the oldest one is deleted, i.e.: ...more >>

Hi All I wonder if you could give some help and advice on the best way of going about the following. I want to transform and copy/import most of the data from an existing database to an new database on a regular basis(on the same SQL 2000 server). I have experimented and successfully se...more >>

Hi gurus, I am fairly new to DTS and the world of SQL 2000. My requirement is to be able to create cubes from DTS. I am able to process the ones I have created manually in Analysis Services, but now I need my DTs package to create the Cubes dynamically. Any help would be very helpful. Th...more >>

Anyone here use DTS and VB6? What are the advantages? I tried executing a DTS package I have installed locally on a SQL Server from my workstation that included an FTP. It would appear the DTS package runs within my workstation instead of executing on the server. I'm not sure if this i...more >>