Hello, I'm going to use a DTS package to move multiple MDB files into SQL Server 2000. Is there anywere that has good example of different parts of DTS package? The package I need to create will keep checking a certain network folder to see if a new MDB exists. If so, I'll move it into the ...more >>

(SQL Server 2000, SP3a) Hello all! I have a DTS package that uses the Data Driven Query Task (DDQT) to invoke a stored procedure on the Insert action (that's the only action that's defined). My source table has a DATETIME column that I'm using as the value to one of the parameters to the st...more >>

I have a .DTS extension file from different server in my C drive how do I import it to view the contents int he current server. ...more >>

I have 50 packages that are going to call one package and I need to set up a few global variables. Is there an easy way to set up all the packages to have the same Global variables? It is going to take a great deal of time to open each package and add 3 variables. Also, what about next m...more >>

I am a little confused here as to how this works. I have package A and it will call Package B (which will send data to Sql the results of the package that called it as well as email results and maybe some other things down the line). I have about 50 packages that will all call this package. ...more >>

I am trying to add a date as a global variable and no matter what I add, I get the following error: Could not convert variable beginExecute from type BSTR to type Date When I hit the new button it sets up a default as String which I normally can change to anything else, but if I use date, it...more >>

(SQL Server 2000, SP3a) Hello all! I have a DTS package that uses the Data Driven Query Task (DDQT) to invoke a stored procedure on the Insert action (that's the only action that's defined). My source table has a column that I'm using as the value to one of the parameters to the stored proc...more >>

MS SQL Server 2000 doesn't seem to recognize an Excel 2003 spreadsheet. What type of file should the Excel 2003 spreadsheet be in order for it to be imported into MS SQL Server 2000 by the Data Transformation Service (DTS)?...more >>

I have a scheduled job which run two dts packages in succession. Both packages are set up to log to sql server and do so if I run the package from enterprise manager. If I run the packages from the job, the job logs show that the package steps completed successfully, however there are no st...more >>

I have a DTS package which has worked beautifully for 2 months or more which I recently needed to migrate to a new machine. I moved the package and all dependencies to a new SQL server, and now all works except for a call to : Set oShell = CreateObject("WScript.Shell") The error handler...more >>

in a sql step of a dts package the code is checking the count of a table. if the count is greater than 0 i'd like the success part to execute, otherwise the failure part to execute. is there a way to have the flow go to a different task based on this conditional sql code with dts? tia...more >>

Hi. I am having problems using the Send Email Task in DTS Designer. I have created a CSV file and am attaching this to the email. Everything is cool until I receive the email. The email has the attachment, yet the name of the attachment is the full path!! i.e CTempMyFile.csv (This sho...more >>

Hi I have build a DTS Package with about 35 Tasks, now I would like to substitute a Value for the Import Query which selects the Sysdate with a global Parameter, so that I don't need to go altering each one of them one by one. .... HAVING MAX(RS.RELEASE) IN trunc(SYSDATE - ?)) .......more >>

Does DTS (or the OLEDB driver it uses) import rows from txt or xls files in their physical sequence in the file? Some experimenting doesn't turn up any instances where it didn't, but I need to be sure that the destination work table will always receive the data in the order it exists in the file (s...more >>

Error message when backing up database from SQLAgent job : ConnectionRead (WrapperRead()). [SQLSTATE 01000] (Message 258) General network error. Check your network documentation. Anyone seen this before ? Know how to fix it ?...more >>

I am somewhat new to DTS, but am an experienced db programmer. I need one DTS Package that will import various tables from one (non sql server) system to the current sql server system. I am not going to be copying all tables (about 250) but probaby about 100 of them. So far, I have been able...more >>

I am struggling with a problem where DTS packages are run overnight via scheduled jobs. However, the jobs appear to be 'hanging' with the status of 'executing', and so they fail to run the following night. The only (manual) solution we can find atvpresent is to pretend to edit the job from the Manag...more >>

Hey all, A simple statement below: DROP TABLE [Table_1] What I'm trying to do--essentially--is this: DROP TABLE [?] And pass in a global variable as a parameter. Conventional wisdom says that with DROP's and CREATE's it's not possible to do this. I say to hell with conventional wisd...more >>

I am using an Active X Script task to instantiate an Excel object using createobject function and it works fine if i run the package manually from my machine as excel is installed on my machine and DTS runs from my machine and not from the server but when i try to run the DTS from the SQL Server ...more >>

Can I programically change the Directory Path property for where the FTP package downloads the file? Or must it be specified in the Package as is? My package code... package.LoadFromSQLServer("servername", "Data Loader User", "", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null, nul...more >>

In a table comparing the features offered by the different versions of SQL 2000, I saw that in the row for DTS feature it said "Deployment Only" in the Desktop column. All the other editions said "Supported". What does that mean?? Paul Sullivan...more >>

I have several DTS packages that perform similar tasks on the same two databases, but I have one DTS package will not execute when run on the server. However it will run if executed from another PC. (Note, in both cases I am executing the package directly form Local Packages, not from a schedule...more >>

Hi! The database is growing with a lot of old logging rows... We would like to keep the production environment nice and clean - but still keep old data in a specific archiving database if specific need is raised. How do I in the most easy and streamlined way set up DTS to move/archive (COPY...more >>

Hello I posted a couple of days ago about this issue that I am having. See post titled "DTS Package error out when called from VB.NET" . I am still having the same problem and have invested many hours into troubleshooting and recreating this package only to be at square one. I have ref...more >>

Hi experts, i make migrate more tables from excel into sqlserver, so i think to use DTS. This tables (more than 200) are all equals and i try tu use wizard and it work. How i make an automation to do this? Thnaks for suggestion! alberto ...more >>

I had to reinstall SQL, and after I re-attached all of my databases, I noticed that all of my DTS packages were gone. I saw in another post that I need to restore my MSDB database. 1. Was this overwritten automatically by the reinstall? 2. What will this affect? Can I do this with user...more >>

Hi , I have 10 Client's sql server databases residing on different systems. Now I want to Pull data from all the 10 database into one Consolidated sql server Database. What is the technology that I should use?? Please Help me Thanks in advance.. Regards Srinivas Govada ...more >>

Can anyone shed any light on this. If I go into the local packages and try to design an existing package it opens a new window with just the name of the package in the title bar. There is nothing else displayed, even the toolbars are missing. I have logged onto another PC and can open t...more >>

Hello, I am attempting to perform an SQL Server7 to 2000 migrations. However where my database schema is concerned I am receiving error messages. ie. ALTER TABLE statment conflicted with COLUMN FOREIGN KEY constraint 'FK_AsdaOrders_RDC_4CAD06362'. The conflict occurred in database RFTest, ...more >>

I have a DTS package that downloads a large number of tables from a remote database into SQL Server. Each download has its own source and destination connection and a datapump. I am still experimenting with the number of parallel tasks to use to get the optimal download time. What I need to is to ch...more >>

I want to run a DTS package to be triggered from a Excel workbook. Please provide a simple sample how to run the DTS package from an Excel workbook or alternatively how to run a DTS package from a SQL Stored Proc with a simple sample please. Thanks Simon...more >>

I want to run a DTS package to be triggered from a ASP page. Please provide a simple sample how to run the DTS package from an ASP page. Thanks Simon...more >>

Hi all, I hope that some can help with the following situation. I have a SQL 2000 server (sp3) on Windows 2000 server (sp4) that has recently developed a memory leak when running a DTS package. When ever a package is run the memory max out at 2 gig and doesn't come back down unless you stop and...more >>

Dear Gurus, How can I move all my stroed procedures from SQL Server to Oracle? If I can do it using DTS then How Can? Please also tell me Can Oracle Objects also migrate to SQL Server? Thanks A lot usman *** Sent via Devdex http://www.devdex.com *** Don't just participate in USENET....more >>

I was forced to reinstall SQL due to some problems we were having. Unfortunatley I didn't know that our old DBA had quite a few DTS jobs that are now gone. Is there any way to recover these jobs?? If so could someone please give me simple instructions? I have to get these jobs back by ...more >>

I'm creating a new connection in the dts designer, I set the "data source:" as "textfile (source)." What I'm trying to do is insert a variable in the "file name:" text field, so that when one runs dtsrunui.exe at the command prompt one can pass in the filename in question to dts, which will i...more >>

Hi all, We have created DTS jobs which copies data from one server to another and truncates the destination before copying the data from source. when we run the job manually it runs fine, but when schedule its failing with the below errors. DTSRun: Loading...DTSRun: Executing...DTSRu...more >>

I am geeting the following error in dts "Duplicate key was ignored" How to suppress this message in dts? Version : Sql server 2000 service pack 3a Thanks Bala ...more >>

Hi all, could anybody please be so kind and help me with the following: I just tried to create a sample for checking some options. So I have the following construct: EXECUTE SQL Task (1): SELECT ID FROM Users WHERE gender = 'female' this rowset is stored in the following global varia...more >>

Hello All I have a DTS package that works fine when I run it from Enterprise Manager, but when I call it from VB.NET all of the components fail. The number of the error message is 0 . I have included code that I use to run the DTS package. How do I troubleshoot this? Thanks for any he...more >>

Hi guru's I have a DTS package that creates a series of text files at the end of each month in order to send data dumps to our customers. I had hoped to fully automate this process except that I cannot seem to dynamically change the file name and destination of the text file! I curr...more >>

I have created an ActiveX script for a Local Package. I am trying to append to a text file, using the FileSystemObject. When I use the code: objFSO.OpenTextFile("c:\text.txt", ForAppending) I get an error. If I do not put the "ForAppending" on the end, I get bad file mode. Am...more >>

Hi All, I am able to execute the DTS from Stored procedure (including Passing Global Variables). I use DTSRUN using xp_cmdshell. But some time (mainly the very 1st time from other system) I get the folowing ERROR. But next time onward that works fine. Can any body suggest why this happens? ...more >>

(SQL Server 2000, SP3a) Hello all! I've got a package that contains other sub-packages. The "outer" package that I'm trying to execute has a bunch of Global Variables (GVs) that control the Source and Destination server/database/credential information. The "outer" package doesn't really do...more >>

I need to copy data from ORACLE database onto SQL Server Machine and I am planning to use DTS to import the data. Do I need to install any thing on the machine hosting SQL Server? On my personal machine I installed TOAD and when I try to create a DTS package connecting to ORACLE, I am able to connec...more >>

Hello - I'm trying to load all the files in a folder. I found code on the web and modified it somewhat. My problem is that only the last file in the folder gets loaded. It loops through and finds all the names, but doesn't kick off the data pump task until it's done looping through the fi...more >>

Hi All, I need some help here! (AS/400) Source file has a field called 'Process_date' and the same is there in the (SQL Server) destination table. I want to compare max (Process_date) of the destination with the source. Only if it doesn't match, the DTS package should run. Otherwise, it sh...more >>

When launching any dts package in the designer an error "The system cannot find the file specified." is being shown. If I click OK I see the connection objects, but none of the task objects show. I've been researching this for a couple of days, and I've seen the articles on www.sqldts.com whe...more >>

I have created a Custom Task and configured the Name property the following way: Private Property Let CustomTask_Name(ByVal sNewName As String) Name = sNewName End Property Private Property Get CustomTask_Name() As String CustomTask_Name = Name End Property I compile the dll an...more >>

Hello, Dunno if anyone out there is yet au fait with Yukon DTS - hopefully there's someone... Containers have a property called TransactionOption the possible values for which are enumerated by an enumeration called DTSTransactionOption. The enumerated values are NotSupported|Supported|Req...more >>

Dear Sir I cannt remove(fix) this error System.InvalidCastException in DTS.CustomTask failed. I read article converting VB 6.0 DTS project to VB.Net. Here is my code: Dim oTask As DTS.Task Dim oLookup As DTS.Lookup Dim oCustomTask1 As DTS.ExecuteSQLTask2 oTask = CType(goPackage, DTS.P...more >>