I am using SQL Server 2000 and I have two user databases defined (ROE & ROE6). The ROE db has a table named Lots and it contains a column titled "OrigLot". Can I use DTS to retreive a portion (SELECT OrigLot FROM Lots where OrigLot >= 233) in ROE.Lots table and overwrite a complete column in ...more >>

Hi: I have had experience doing the following with ActiveX script tasks: 1. Setting the SQL Statement of a data pump task so I can change the WHERE clause before that task executes. 2. Dynamically setting the tablename for tables like MMDDYYYTableName, so the data pump task knows the right ...more >>

OK, how do I convert a SQL Server database file to an Access database file ? Randy...more >>

I am trying to create a DTS package using C#. I have done this in VB6 without any problems. However, when I convert everything over to C# I get the 'System.InvalidCastException'. I am running windows 2000, SQL 2000 sp3a. I have also followed the instructions in using DTS provided by "ht...more >>

Hello, I am trying to connect to paradox database for the purpose of updating the record(s) in DTS ActiveX Script Task. I used the following connection string. But I get an error while connection. I have "UMTest.db" and "UMTest.px" files in the "C:\MYDBPath" in my local drive. Set objRs ...more >>

I'm making DTS packages... So if I have a Connection, and Execute SQL Task, and then I want to use an Active X script to do more things. How do I get the SQL results from the EXCUTE SQL task in to the active X task? For example: Variables I have filled in the sql task, or Cursors I have f...more >>

Hello, I use SQL 2K on a Win2K box I have created a DTS package, the data source is a stored procedure with an integer for the only parameter like: exec myproc intparm When I have a literal for the parm, it runs fine. When I replace the number with a question mark, I get this messag...more >>

Hello there I have an empty database that i need to fill it with another database which is similar. (backup of the current database) In the database i have forign key constraints. So in order to enter data to one table with foreign key i need to add the data first to the table with the primar...more >>

Good Afternoon Everyone: I have a DTS Package that completes successfully when executed on the server as the SQL Service Account, but when it is scheduled it fails. Here are the details: Error Message: DTSStep_DTSCreateProcessTask_1 DTSRun OnError: DTSStep_DTSCreateProcessTask_1, Error ...more >>

I am loading a large amount of data in sql server from a text file, some time the package fails with follwong information written in exception file Error at Destination for Row number 32376. Errors encountered so far in this task: 1. Error Source: Microsoft OLE DB Provider for SQL Server ...more >>

Hi all, I need to transfer data of a production server (as400) which mutates 24 hours a day to a sql server 2000. Since it is important that this transfer is right and complete. I want to check with hash totals and recordcounts if the transfer was allright. What is the best way to do this?...more >>

Just wondering if anyone can suggest any solution to a problem I am having. I currently have a DTS package which is reading in a CSV file on a daily basis, the only trouble is that sometimes this CSV file can be of size 0. Common sense tells you that DTS should notice this and simply read in...more >>

Dear, I have a .hed file. I want to convert it to SQL Database as a data source. How can I do so? Can I export it to an Excel file? What program can I use to open it? Thank you. ...more >>

Hi I have this problem on two of our servers, get the problem with different SQLEM's. When creating & saving a new package - no problem, but can not open and save an existing package. Any help / suggestions would be apreciated Thanks Emile...more >>

Hi, I have a local DTS package on one machine and want to copy it to another machine via CD. I've rooted through BOL and a bit of Google but I suspect I'm not asking the right questions. Any help available here on this? An example would be great! Thanks, Paul ...more >>

I have an activeX task that performs a loop and at the end of every loop i want it to execute the exec sql task. I have tried: Set objSQL = DTSGlobalVariables.Parent.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTask ..... objSQL.Execute ...more >>

Hi all, I have the following file and I use DTS to import data into this table but I am keep getting errors because of the date format in the file. This file is 2 Gb of data and the table has 230 columns. Does anyone has similar problem and has a solution for it. Also, this table is copy...more >>

Greetings all. SQL Server 2000, sp3a Trying to concoct an ActiveX script task that is a generic error processor - taking the exception file(s) and description of the task that just failed (the previous step in the workflow) and dynamically adjusting properties on the SendMail task to att...more >>

We are receiving a reporting database from a vendor nightly. We want to upload this data and structures to SQL Server nightly. We want it to be as flexible as possible - if the vendor adds/deletes a table/column, the import job should handle that. Apparently, the Import/Export wizard in S...more >>

Hi, I'm new to sql, Importing a large flat file (positional text) into MSSQL using DTS, records are occassionally skipped. On two spot checks I found records present in the input file but missing in MSSQL. No errors were generated during import. Please help Thanks -- chris ckloss@m...more >>

Hello, Does anyone has the example for uploading the file to a different server from the server where the DTS process runs using FTPTask. I have done downloading the file to the server where DTS runs. I need the example for uploading. Thanks. ...more >>

I am tring to import multiple xls files into a sql table. I have am able to get the file names using a file system object, but what i would like to do, is once i have the file name, change the name of the excel connection object to that name and then perform the data transformation. once thi...more >>

I am working with a DTS package and within Disconnected Edit it shows more tasks than what I actually have in the package. Tasks are showing up in disconnected edit that do not exist in the design sheet. Is there any way to delete these? Thanks...more >>

Can anybody tell me if i can retrieve the specific records without using filter that is where clause...more >>

I have a stored procedure that does a qc check on 2 tables. It contains a case statement that checks to see if a value falls in a certain range. If it does it returns a success message, if it fails it returns a failure message. The code is below Select Case When ((SELECT SUM_KEY_FIE...more >>

I have received the "Not enough storage is available to complete this operation" message from a SQL Server 2000 DataPumpTask that has been running correctly on several different servers for a couple of years....until I tried running it on Windows 2003 Servers that have recently been upgraded to ...more >>

Hi all, I am really new to DTS programming so I need some help. I have a DTS package on my SQL Server with a dynamic property on it which i want to use to specify the path of my source file. HOW.. in code (VB.NET), do I execute my DTS package passing in a new value for my dynamic property. ...more >>

All, please may I have your assistance with the following? I'm trying to reference an existing DTS connection in my activeX script task rather than instantiating a new connection object with plain text connection details. The objective of the DTS package is to upload an XML file details into a ...more >>

Hi, I'm trying to disable DTS 2005 tasks at run time using an expression to set the task's "Disabled" property. The expression I use is "(DT_BOOL) @[User:: DisableJobA]" where DisableJobA is a global variable set to True. The task seems to ignore the expression at run time and never ge...more >>

Hi All, Our partner created a DTS package in sql 2000. However, we are still running sql 7 and can't upgrade in the short term. Is there anyway to open that DTS package in sql 7 or somehow "save" the package in sql 2000 as a sql 7 version? Or is this mission impossible? Thanks, bluemug ...more >>

I have a need to use some pieces of a SQL Recordset and combine those with each filename in a folder. I then need to output each of those combinations to a file. I know I can do a FOR loop to get all filenames in a folder and I can get the information from SQL without any issues. My lack of kn...more >>

Ok, I am using Windows Server 2003, Sql Server 2000 version 8.00.760 I have a batch file that runs a DTS package using DTSrun as follows : DTSRUN /S "(local)" /E /N "EVA mod_CR_CYR_INSTR" /L "C:\EVA DTSPackage Scheduling\DTSScheduleLog.txt" /W "-1" When I run this batch file or schedu...more >>

Hi all, My problem is quite simple. I have a small c# application accessing a DTS package to read and display info about it. I can access any type of standard custom tasks and its fields, but I lack documentation about DTSOlapProcess. DTS.CreateProcessTask2 oCreateProcessTask = (DTS.CreateP...more >>

I would like to write a DTS package to import a number of Excel files from a network directory to a single SQL Server table. Assumptions: I am assuming that the coulmns are constant among the Excel files and only the file content is different. 1. Is there a function to read a predefined netwo...more >>

I have an update statement that I run as follows from a SQL Task... UPDATE "AS400Machine"."AS400DevLibrary"."FileName" SET FLAG01 = 'N' There is only ever one record on the AS400 file. I have ran this SQL Statement from within the AS400 and it updates it fine. I run a DTS Package t...more >>

Working on an automation of MS Exchane Server 2003, I have to create appointments (with CDOEX) in a DTS ActiveX Script (see below). Do Until Rst.Eof Set Appt = CreateObject("CDO.Appointment") With Appt .AllDayEvent = Tru...more >>

I already have tables in my SQL Server 2000 database. I have several things that I need to do - (import sql server 2000 tables into MS Access database for conversion) 1). cleanup the data from MS Access 2). break out the data from some of the MS Access tables into sql server tables ...more >>

I'm creating an application that runs a DTS package with an "Analysis Services Processing Task" in the package. When I run the package in the main thread, it runs fine. However when I try to run the package via a separate thread (preferred so the application isn't "frozen") it won't even load...more >>

Hi, Is there any way to programatically rename all DTS packages on a server to 'New_'+ old_name or save them all as 'New_'+ old_name (and then I can delete the old ones) Thanks ...more >>