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

I am experiencing a random VBScript related error.... While looping thru about 80,000 rows of data (where I am creating an xml files and running an Update SQL statement that updates the row for the one I just created), I am getting a Timeout error message related to the Update statement. ...more >>

I have an activex object in a DTS package which contains hard-coded info that really should be dynamic. There is an OLE DB Property called "Data Source" from the UDL file that appears to contain the value I want. Is there a way to obtain that value? ( I am new to DTs and do not know the righ...more >>

I have created a DTS Package with a Copy Objects step. This copy objects step copies some tables, their indexes, and data to a server that is housed at an ISP. The account that I log in with on the external server is a dbo for the database I'm targeting, but my permissions are limited to tha...more >>

How to load XML File into sql server db through DTS ? Pls let me know. Thanks...more >>

Hi, I have to execute the DTS package from ASP file. But the following line throws error Set oPkg = Server.CreateObject("DTS.Package") Error type: Server object, ASP 0177 (0x800401F3) Invalid ProgID. Does anybody know the solution? Thanks, Mamatha -- Message posted via http://w...more >>

Is there a # of fixed fields columns limit on a text file source in a DTS package? I have a file that has around 200 fixed fields? I even question whether or not I can create a SQL table with 200 columns? ...more >>

Anybody can give me a directions how to get the results form a stored procedure (all SELECT it is a report thing) and put it in txt file and send in a email ... TIA...more >>

SQL 2000 I got a table with file names and path for the Excel files to be loaded into a sql table. My plan is to use DTS and global variable to assign the path and file name and use that as the source for the data-pump. Any thoughts or sample code to achieve this ?? Thanks In Advance ...more >>

Hi There, We have a package in production that has not been changed in awhile. It = runs every day on a scheduler off hours. It run when there is no other = interference on the server. This package at one day did not run three = subsequent steps out of many it was supposed to run. The DTS log ...more >>

I'm trying to save a basic DTS package, but for some reason the radio button for SQL Server Metadata Services is greyed out (disabled) and I don't know why. I'm running SS2K (sp3a) on W2K (sp4). I've never seen this before. The three other options are available as usual. Anyone know why this...more >>

Are there any routines out there that will automatically convert a table (A) with numerous numeric fields to a new table (B) with just one numeric field. Thus the number of records in the table (B) would be the number or records in A mutliplied by the number of numeric fields. Thanks in advan...more >>

We have a software application which runs on a SQL Server database. We distribute our blank database as a SQL Server Backup file, but how do I distribute my DTS Packages? Thanks for your advice, - Joe Geretz - ...more >>

Im trying to import an html file using dts. When I click on the file when using dts designer, I get the message: External table is not in the expected format. Any ideas? -- SQL2K SP3 TIA, ChrisR ...more >>

Hi, we have a user that create some dts packages. He is the owner of the pachages. He try to do some changes after saving them, but when try to save the changes a message is displayed: Onlye members of the sysadmin server role can change the dts or the owner. He is the owner, but he canno´t...more >>

I created a DTS from a txt file and I transform the file to skip some row with condition. The txt file is in fact a report that has header, detail and footer and I'm importing only the detail part of the report but would like to have part (the BRANCH number) of the header as a field. Here's th...more >>

I read an Excel file which has a char column header, then an empty row and then numeric entries. Doing this, I get the Char column header as my column name in SQL Server, but I can never get the char column header as an entry in my database, even not when inserting a row above it. Any ideas ? ...more >>

Hi, I have a (for insert, update) trigger on a table that get loaded with data through a dts package. The trigger calculates two fields together to update another field (checks and balances). When I update one record the trigger works but when the data gets inserted through the dts packag...more >>

Is it possible to use shared (public) ActiveX script functions inside a DTS package, that will be placed in a sigle code block and called from various transformation tasks instead of being replicated in each of them ?...more >>

Hi, I have many dts packages that references a db on a linked server. I often use the db on the linked server as a source for fetching data. When I do this I must use the four part naming method, specifying server, db, owner and object (table). The problem is that I am now in the develop...more >>

This is a little convaluted, but here goes.... SQL 7 machine ------------- I have a stored procedure on the SQL7 machine which: 1. truncates 5 import tables 2. deletes previous copies of 5 csv files, called via xp_cmdshell 3. unzips a .zip file using Winzip command line, called v...more >>

All, First let me explain My Application's deployment scenerio. My Application server is on win2003 + IIS6.0. I created a local user called XYZ on the server. My web application's pool run under this user's identity. The DB machine (SQL Server 2000)on which the DTS is present is...more >>

I have created a DTS package with 3 steps. When I execute the package from within Enterprise Manager the package executes successfully. However when i run the package from within the asp page I get an error on the 3rd and final step. Executing shipTableTitles from sqlServer1 Step [DTSStep_...more >>

hi, I have a problem with DataPump in recognizing the row length in a text file. I have a flat file with varibale row lengths. The first row is around 30 characters ends with null and the next couple of rows with 70 characters ends with null. The DTS is picking up only 30 characters from a...more >>

I am using Text File(Source) object to read the data from a flat file. Is there any file size limit to read the data from an ASCII file? I am trying to read the data from 700+ MB file and when the file format is fixed field, I am not seeing the data in the editor to map. I am presuming that th...more >>

I'm trying to pull data from a dbIV database(Goldmine 6.5) using the dbIV driver that comes with DTS. 'Microsoft JET Database Engine: "Index not found"' What is required to fix this problem? ...more >>

Hi I have created a DTS package. I one of the steps I execute a exe.application that if I want to return a value if it was successful or not. In execute process task a can set a return code for success. But what if a want to return a failure code an continue the dts package? How do I do ...more >>

I need to create a DTS Package accessed through ASP. I currently do this through VB and this interface allows the users to select a file through a windows scripting host dialog. The package was created in SQL enterprise manager and saved as a VB file after which the source file path was chan...more >>

I am upsizing an access DB to SQL Server. I'v had trouble running the upsizing wizard, so I imported both the data and schema via DTS. ALl the data and schema imported just fine. The field types were on target for the most part. My biggest concern is the relationships which din't make it as...more >>

Hi, The DTS transformation of a text data file onto a table always skips the last record. But the last record seems to have the LF similar to the other records. Are there any reasons it might do so? Thanks, John Jayaseelan *** Sent via Developersdex http://www.developersdex.com ...more >>

I am unable to add a transform task to my DTS packages. Recently I started to get an 'access denied' popup window the first time I opened my packages. The package goes ahead and opens and looks ok and I can run it but I can't add a new transform task. My method is to add the two connections...more >>

I have created a DTSpacket how takes a Excelfile and insert to a sqlserver table.The Excelfile then moves to another path. It works okey but I have a problem when I place two files in the same path because the file has the same name. Is there some way I can makes it work?? I get the files from m...more >>

Hi I'm trying to figure out the best way to identify which packages are affected by changes in either the source or target databases. These are my findings sofar: 1) Rely on accurate design documentation for the DTS packages to find affected packages. 2) Store the packages in Meta Data S...more >>

Hi. I have a dts package that is saved as a structured storage file. The package is executed via dtsrun and the logging is sent to a log file. In my package are several SQL tasks. How could i send my SQL print output to the dts log file? Much thanks!! Aaron ...more >>

I have currently trying to import an excel spreadsheet with named cells to SQL thr DTS.. My problem is that how to I skip those cell that are empty in the spreadsheet using DTS activeX? This is what I tried? (I have tried checking for isNull) Function Main() 'Check for not Null ...more >>