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

I have imported data through dts. But when viewing the data it is rounding. eg 0.10 is imported as 0 What has happened with the import....more >>

Does DTS support Multi-Byte and Unicode characters ?...more >>

I am executing a sql file through dts. Is is possible to get complete sql execution log (i.e. so many rows updated etc.) and not just step failure reason. Please help me with this. Thanks, pradeep...more >>

I am developing on a test system and I want to transfer several of my files to another test system (at home). Can you transfer a DTS Package from one server to another? Export does not have a utility to select a Package. Any assistance will be greatly appreciated. I would hate to have t...more >>

Hi guys, I wonder How can I build a Store Procedure with two connections? What I need is to develop a SP to backup the SQL DB that's on Internet (Hosting Company, and they do not replicate it, well, not without any more money). DTS does not have any tool to do that, just ADD, DE...more >>

Any idea how can I create a global variable to change the database name in the source and destination tab of the tranformation (the database name part only - my_db.table1 to my_other_db.table1)? I know I can create the global variable to change the name of the database in the tranformatio...more >>

I can create DTS packages on my PC to be stored on another server, but I then try to open it to edit it, the DTS Package editor opens, but with no toolbars, menus and DTS tasks - just an empty white box. My client PC is WinXP, the server is Win2k and the database SQL2000 SP3 Any ideas anyon...more >>

I created a DTS package that produces this error when run: "Data for source column 1 ('Text') is too large for the specified buffer size." When I looked at the column within the Transformations tab, it has a datatype of varChar(255). I believe that the problem is that the data from the source...more >>

I have created a DTS Package with the following Lookup named LookupID: select ID from ut_TableName where (PersonName LIKE '%' + ? + '%') The code simply searches for a phrase (represented by '?') and gets all similar matches within the table ut_TableName. I have a transformation (VBScript) ...more >>

I have a package that performs a FTP task to download a file. The FTP step completes successfully but the file is immediately deleted. I can watch the file download, complete downloading and then it immediately disappears. It seems to be associated to one particular file. The file is a zip file...more >>

Hi Everyone, I am pretty new to DTS and am trying to setup a global variable. Basically I want to do the following: 1) Select Max(date) from table into global variable 2) Use global variable in the SQL portion of my transform data task to only select rows that have a date greater than my ...more >>

I had created a package with Two Execute Process Tasks (Each execute Process task bcps the data into separate table) One Activex script Task. Overall the Package Behaviour is Whenever the Activex Script Task is sucessful automatically Two Execute Process Tasks should run in Parallel (...more >>

I noticed that you can save the dts package as a visual basic module. If you do that, how can you execute the code? Do you have to do additional programming or is it a plug-and-play type of scenario. I made a form and included the references for DTS using VB6, but it did not work. In f...more >>

Hi, Do the users have to be OFF the database system when DTS jobs are executed? Please let me know. Thanks...more >>

Hi Everyone Is it possible to execute MS Access Query from within a DTS package. In the connection to the Access database the queries within the .mdb don't seem to be exposed Many thanks geoff ...more >>

Hi I am trying to use transfer database task to move/copy some database from A server(sql 2000 server) to B server (sql 2000 name instance which has SQL 7 as default instance). But, the task failed with "unspecified error" message. I couldn't find more information other than "unspecified error...more >>

--SQL SERVER 2000-- I created a DTS Package to export to a text file and when i execute it on the SQL server itself it works fine. But if i execute it from a sql client workstation it gives me an error that say's "Error Opening Data File: The Device is Not Ready". Hmmmm having trouble fi...more >>

Please let me know how to create comma delimited file and comma tab delimited file from database table. Which components i should use in DTS. Thanks...more >>

Hello, I am new to MS-SQL server and am trying to do something some of you have done before. I am attempting to build a DTC that will run two sql statements in one transaction. First SQL statement-clear the table I am working with delete from APPDEV.IVRtrst Second SQL statement-grab data f...more >>