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

We have a DTS package that loads VFP data into a SQL Server on a separate machine on the same network. This process takes ~12 minutes and involves many of the records in many VFP tables (1.3GB). Our CIO has expressed an interest in moving our SQL server to a remote location and keeping our Vis...more >>

Hi, I have created a VB program to perform DTS tasks for data transfer from ACCESS database to SQL Server. The DTS are created by saving the actual DTS packages as VB file and used those bas files in VP app to run the DTS programmatically. The process works fine most of the time. But occa...more >>

Hi, Currently when I perform a export to excel, those fields with datetime will only show date. I understand that I can open that excel file and change to the correct format. But I would like to have it set automatically after the export is done. How should I do so that it can show out the...more >>

Hi, Could someone help me. When I execute my DTS batch with a script ActiveX in VBScript, I have the following error message : "ActiveX Scripting Transform (DTSTransformation__5) doesn't succeed to initialize script execution engine". Thank's a lot in advance. Christian ...more >>

When using DTS to copy Tables/Views from one SQL to another, some of the tables/views start to copy but error out. Is there anyway to fix/rebuild the existing tables/views before copying or worst, is there anyway to let as many copy before it fails. I understand this would not get me a c...more >>

I used DTS to transform data from ORACLE 8.1.7 to SQL Server 2000. an error message appears while moving data in new table DBTYPE_DBTIMESTAMP "Data overflow. Invalid character value for cast specification". field in oracle with Date type. the retrived information through oracle ODBC ...more >>

Hi, I have a DTS package that imports data into SQL 2000 from an ODBC source on another server. There are only 2 steps, empty the sql table and import new data. This package runs with no errors when it is run from EM on the SQL server. I need to be able to trigger this package from a ASP pag...more >>

I have a fixed length text file that I wish to import into SQL tables. The text file will contain 2 different types of records. Firstly, a header record, which is immediately followed by X number of detail records. Each record is 80 characters long, separated by a CRLF, and the type of reco...more >>

I have data in text file , delimited with Pipe and with help of DTS package pump data to SQL server. The issue is, the text file some rows can have 32 columns and some can be 33 columns and so on. Number of columns range from 32 - 40. How do i tell DTS package (vbscript) to recognize the c...more >>

I need some help with the way I make dts packages that bring in data from outside data sources. A typical DTS Package that I've made Deletes the records of a table then on success connects and pulls down a new set of records and then on success does and update to another table from the ne...more >>

I have a DTS package the does an FTP --> Text File Data Source -->>> Multiple Tasks -->>> SQL Server database. The input source file has one row that has12 fields. The multiple tasks basically read 3 columns from the source record and insert a new row in the destination table until all 12 ...more >>

I have a DTS that uses global variables to got to the network, get a file, unzip the file, import the files into sql and then move the file to an archive. It works great as a DTS. But when run it as a job it sits at Running Step 1...and I have the manually Stop Job. Then I get no errors...more >>

sorry in advance for the newbie question. i need to insert into a table using a global variable in a "where" clause. so something like insert into datasourceA.table1 (field1, field2) select field1, field2 from datasourceB.table1 where field1 > aGlobalVariable i can do the part without t...more >>

What is the best way to import different flat files that are in the same directory using one package? *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it!...more >>

without having a manually controlled external value set to test, is there a global property or something that can be tested to let the scripts control flow, even just whether or not to issue MsgBox statements? doug ...more >>

I am trying to import some data from excel to SQL server table. In excel file there is a column which is mostly empty [around 99 % rows] so when I am importing the file. the DTS package is putting null in all rows even if there is a value in that row for that column. is there any bug in it? do I ...more >>

Hi there, In DTS, Can we use temporary or global temporary created table in DATA PUMP TASK for Exporting data from Server1.DB1 to Server2.DB1 ? Here is case : In DTS Package. Create table ##Global(xyz int) on Server2. Server1 ----- Data Pump Task----->Server2 In Data Pump Task ( My...more >>

Hi, I'm trying to import an ms access database into SQL server using DTS. I have read all the postings and tried all the suggestions and I keep getting errors. I'm getting: "not a valid account name or password" "error during initialization of provider" Here's how I tried importing this: ...more >>

H! I need to export Excel worksheet data into a SQL Server table. The Excel worksheet has 5 cells in it and I need to insert 5 cells data into a text field of a table. Is that possible? All I am looking for is ActiveX code. I used this article (see the link) to set up my script (just to make ...more >>

I have written several DTS tasks in EM that run nightly. I am moving my data from one SQL Server 2000 installation to another SQL Server 2000 installation. Is it possible to copy my DTS tasks from EM on one machine to EM on another machine? -- Regards, William...more >>

Is there a switch that can be used with bcp to include the column names as part of the resulting file from a queryout command ? Thanks in advance ...more >>

I've a minimal SQL Server installation in my desktop PC and a source text file containig my orders. From my desktop is it possible in DTS to channel data from my single source text file to a remote destination table in a remote SQL Server? In my network environment is forbidden to share folder...more >>

Enterprise 8.00.818 DTS package on an Active/Passive cluster with a transform data task that loads data from some Excel spreadsheets. The package works fine when one node of the cluster is active but consistently fails on the transformation task (see error below) if we failover onto the oth...more >>

Dear All we recently put in a DTS request to move 36 million records from a non SQL Server to ours. At 33 million it failed, which was a bit annoying as it had been running about 19 hours. Is there a way of stopping it from rollbacking the records ? Thanks J...more >>