Hi Darren, thank you for your help, but I really tried EVERYTHING I could, so your help is very helpfull. I changed the Ctype to TransferObjectsTask2 and it returns the same error. ERROR: An unhandled exception of type 'System.InvalidCastException' occurred in Gman.exe Additional informa...more >>

When you schedule a DTS package, the job is setup using the GUID of the version of DTS package. How can you setup the jobs so they run the most current version of the package? I don't want to have to re-setup jobs everytime I create a new DTS package version. Regards, Rob...more >>

Hi, I am asked to move all data from one database in Production to Development everynight. When I try to use the Import/Export Wizard, it fails because when the data in Development Server is droped, it will violate the Foreign Key Constraint because it drops One side of the table first w...more >>

Hi, I'm writting some VBscript ActiveX code inside a DTS Package, and i'm getting a parse error. (This script runs fine in Access). I believe it has something to do with the "TO" porttion of the case statement ( case 1 to 30). any help would be appreciated. Here is the code. ' VBS...more >>

Ho can I create a DTS, and run it as a script ? I mean... like cscript or wscript. I need to generate a DTS script for the testing environment, and then run it in the production environment. So I need to configure the script with the sql server password, etc. Thank you so much. Bye --...more >>

I need to create guid in a activeX script. How do I do this? *** Sent via Developersdex http://www.developersdex.com ***...more >>

I am re-writing an old BCP job using DTS. The job imports a fixed length text file which includes date fields in the format yyyymmdd. Sometimes there will be no valid date on a record and this is held as '00000000' in the text file. This should be moved into the database as a NULL date value. ...more >>

hi All I am new to DTS... can anyone send me some good link or e-books which are freely available over Net for C# and DTS Programming Thaks Silent Ocean ...more >>

Is JET-OLEDB really the only way to read data from Excel into DTS? I have values in several single cells and the Excel-Worksheet is more a form than a database-like table. Is there no way to read this? ...more >>

Hi, I have a package that imports data from 3 different Access DB's into MS SQL. I am using loop mechanism expalined here : http://www.sqldts.com/default.aspx?298 I modified that sample to do double loop: outter loop itirates through recordset of databases, inner loop recordset of tables in cur...more >>

Does anyone know if there is a beta newsgroup for Sql Server 2005 DTS? Thanks! ...more >>

Hello to all.. (sorry but my english in´t that good) I read avrey article on how to execute the old VB6 DTSPACKAGE and everything goes well but this line is not working. oCustomTask1 = oTask.CustomTask An unhandled exception of type 'System.InvalidCastException' occurred ...more >>

In the below ActiveX script (taken initially from BOL) I compare file dates & only want to continue the DTS if if the file date is newer. However, if the file date is NOT newer the Step is "failing", whereas I just want to STOP The DTS is as follows (in my best plain text graphic desig...more >>

Is it possible to setup DTS in SQL Server 7 in such a way to make a copy of a local database that is sent to a file share in a domain for archival purposes? Because the server doesn't meet certain company security requirements, the requirement is that it be moved into a workgroup. I am attem...more >>

I'm trying to create an update query that updates a field to the persons current age using DateDiff. If the person's anniversary has occured this year, I need to subtract 1 from the DateDiff result to be accurate. The query logic below works perfectly in a Select statement, but I get a convers...more >>

Hello, I currently have a package that has 10 paths running in parallel. If any steps on any of the paths fail, then I want to send out an email. I would prefer to use a single email task. The task would loop through all of the steps and see if any failed. If anything failed it would include ...more >>

Hi I have two packages which are to be executed one after the other, so is there a possibility of calling a package in another. and also the the procedure or syntax of calling. Thanks Sunil *** Sent via Developersdex http://www.developersdex.com ***...more >>

HI,i am trying to call stored procedure from ASP page, below is my coding. But i dun know why i fail to call the stored procedure.Can anyone tell me what's wrong with this coding? THanks Set objConn = server.createobject("ADODB.Connection") objConn.open Set objCommand = Server....more >>

Hi, I have a DTS package which will be called by a front-end application (C#). The way we are handling it right now is to create a stored procedure to execute the Create procedure dtrun as master..xp_cmdshell 'dtsrun xxxxxxxx' the procedure "dtrun" will be called by the application. ...more >>

Hi - I have a DTS package that reads two flat files and imports the data into SQL Server. Our requirements have changed and the two files I have been importing are now merged into one file. Therefore, I would like to modify my DTS package to only import one file and redirect the DTS tasks...more >>

I have a DTS package which imports data from an Excel spreadsheet into an SQL Server database. The package works fine, but I would like to take the package to the next step in automation. How could I call the package(from VB ..Net or QA) to be executed with only one change in the package: th...more >>

Is there a way, other than scripting a loop to utilize the Bulk utility, to Load all the XML files in a particular directory into a XML data type column in a 2005 table? ...more >>

The subject header pretty much says it all, except that the only views/tables that it seems to have trouble with are ones containing fields with the text datatype - even if you don't put the text field in the view. Using the Transform Data Task, when I try defining the columns for the fixed-w...more >>

Hello all, In some cases I get an error when I try export to a file (from another file or database table) which seems to be related to the amount of columns. When I export from a file to another file it works for 37 columns but SQL enterprise manager crashes when I try to export 38 columns. ...more >>

Hi, I need to export some data to a text file from sql server. I'm using Sql DTS to do this. I also need to have a header in the text file followed by the data exported from the sql database. I created a text file with header then used dts to export but the header gets deleted when the dts ...more >>

I have to read an Excel-File into DTS to append data to a SQL database. Within the Excel file I have my data in columns and not in Rows. Is there a possibility to read this directly through JET OLEDB? ...more >>