Hi, What's the best way to have a single point of config for my databasenames? I use the dynamic property task in all packages to set the UDL path of a database connection with an environment variable. This works fine when I run it manually (because I set the variables manually as well), but w...more >>

Hi all !!! I need to execute a DTS package from a Visual Basic program. the questions are: Q1) it it possible to make the packages run asynchronously ? the package itself will notify the user by mail about the execution result, so I want the visual basic program to end inmediately after th...more >>

Hi, I have created a VBScript in an ActiveX object using CDO 1.21 to connect to our Exchange server, look for an email with a specific Subject Line and save the attachments into a directory folder on the server. The attachments contain raw data which are later imported into tables. The...more >>

Hi, can I change a DTS from a server to another server without having to redefine all connections inside it including transformations?? thanks in advance, Rita Ferreira...more >>

I'm would like to import records I select with a SELECT from one database to another but maintain the identity column values. I've read where I can do this by setting IDENTITY_INSERT ON. From the Import wizard on the enterprise manager, I am selecting 'import using a query', then specifying: ...more >>

Hi All I want to install the DTS package in client machine which is not = located in my LAN. Upto now iam saving the DTS package as .dts file and = copying that one in client machine manually. Is there any other way to = install the DTS package in client machine. Thanks, Vasu....more >>

Hi! Anybody done this? (topic) I have started to manually convert the VB6 to .Net code. While i wait for the VS.Net IDE to complete a who-knows-how-long-? Search & Replace operation on this 3,771Kb .vb file, I am writing this message to see what the community's opinion is on how best to a...more >>

Hi all, I am getting this error message when executing a DTS from a Stored Procedure. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSDataPumpTask_1 DTSRun OnError: DTSS...more >>

I use a Transform Data Task to copy several tables from a Progress database to a SQL Server database. Durring this process each table being copied uses another license on the source database and then releases them all when the DTS job completes. The problem is that sometimes there are not enough ...more >>

I'm trying to import a column of mixed data from Excel to SQL Server. This column contains some numeric values and some alphanumeric. I was getting null values for the alphanumeric values until I used disconnected edit to change the Extended Properties string to include the IMEX=1 parame...more >>

Hello, I'm dumping data into the database by 1. FTP the text files from unix server to windows. 2. Load the data into the temp table and wrote the vb script (if .. else..) to convert the dates and logical values and numbers. 3. Load the data to the base table from the temp table ...more >>

I am trying to execute a sub package that contains the Analysis Services Processing Task. For some reason the package will not execute. For example: Package 1 calls Package 2 that contains the Analysis Services Processing Task. When I execute Package 1 nothing happens. The task executi...more >>

Does anyone know if it is possible to add your own custom messages to the DTS Package status messages from within an ActiveX script task in the DTS package? I'd like to put out some information at the beginning of the DTS package status message that you can see when you look at the job step hist...more >>

How reliable is DTS? I use the DTS utility at work a great deal and often either save the package to SQLServer or complile the package as a VB executable. I have often found the packages will not run properly, but will run smoothly after a reboot. Has anyone else experienced this behavior? -No...more >>

I found a few entry points in dtsui.dll which look like they may do the job. ActivateDesignerWindow, CloseDesignerWindow, CreateDesignSurface, InvokeDesignerCommand. I have not found a COM interface for this DLL. I don't know what the call parameters are. We are doing package management outside ...more >>

The scenario is probably pretty common. There is a lot of new DTS package development work by a number of people at our location, and others. The target for installation is a production server located elsewhere. Everyone here has access to the production server, to look at data, perhaps make schem...more >>

I'm trying to import from a dBase table whose name changes every day based on the date. So I add a Dynamic Property Task, select the copy data task in the tree, then select the SourceSQLStatement property. At this point I have a choice of how to set the value -- based on a query, ini file, a con...more >>

I am a newbie to active-x and am trying to use the code at http://www.sqldts.com/default.aspx?266 but to do something a little different. I have a last_name column in the source that I need to evaluate the number of spaces and perform an action based on it. If one space, take the data bef...more >>

Why, when i scheduled a dts package containing an ActiveX Dll Task, the job doesn't enter in the ActiveX?...more >>

Is there any way we can eliminate duplicates while bulk loading the data from a text file to a Sql server Database Thank Reddy ...more >>

I'm very new with ActiveX Script and I would appreciate if you could review this script. The script works but I will need to add all the tranformations I have in my dts. Is there any way around that. If not, can my script be shorter than this? I feel I'm declaring too many variables. Func...more >>

Hi there, The insert trigger that I created on a table does not fire when I DTS data into the table. Is this by desgin or is there a way/switch to make the trigger fire? Please let me know if you have any ideas? Thanks, Danny ...more >>

Hi I have a directory that will have many input files (~10,000), all with different names but following the same naming convention: nITEMS.TXT Where n is an alpha-numeric string of variable length; in other words, all the filenames will all end with "ITEMS.TXT" The structure of these...more >>

Hi All I'm looking for some information on how the 'Copy SQL Server Objects' task works. We do a nightly copy of 50+ tables from one database to another. Sometimes, after we have made some modifications in the source database, the copy fails. Say the task fails on table #40, what actuall...more >>

I have a DTS package that creates a weekly text file on the desktop (e.g. WeekEndingYYYYMMDD.txt). I want the package to upload that file to an FTP site. Is that possible to do? I see that there is a File Transfer Protocol Task in the task menu choices but it seems like that can only be config...more >>

I am trying to import a text file using DTS. The file is not delimited by tabs or commas so I have to use fixed length. When I scroll to the right of the preview screen, I see that the end-of-line (red vertical line) is at the end of the last character of the first line. But there are othe...more >>

We have created a DTS package and moved it to another server as a structured storage file. When running it all the steps worked fine, but when schedules we noticed we had data missing from one table. After some time trying to track down the problem it turned out that one of the workflows was inc...more >>

Hi, I am having a problem executing dts package fron vb immediatly after first execution.I can do this in enterprise manager though. In order to reexecute it from vb i need to exit and then login back. i have code to close all the connections before executing the package in the vb prog...more >>

Hi, i have a DTS that connect to SQL Server database, the=20 settings and permissions of the conecction are right, =20 however, when i try execute it, the DTS failed with the=20 following error: Sql Server does not exist or access is=20 denied. Any idea, Thanks=B4, Leonardo Gaitan ...more >>

I'm setting up an FTP Package on windows 2003. Somehow, I have a quirk going on. When I try to use ftp.exe on Windows Xp it works fine, but when I use ftp.exe on Windows Server 2003 then it takes forever to list the directories and doesn't end up working. When I use that FTP task in a...more >>

hello! I was trying to use DTS to copy data from excel to SQL2000. In the spreadsheet, it seems like if it is blank or empty values, it is defaulted to nvarchar (255). I tried formatting the columns in the spreadsheet to numbers, since my destination column in SQL2000 is a numeric (18...more >>