Hello, I have an issue with DTS. I have had a package that has run for several month without issues. But all of a sudden, the package is creating files with excessive white space. A 20 MB files is grown to 909 MB. I have checked and there are no new updates applied, and there is nothing...more >>

Hi, I'm importing a space delimited text file into a table that has specified data types of int and smalldatetime -- which is throwing the error, "conversion invalid for datatype on column pair" as the source file is a text file. I don't really care too much about the date, as it isn't reall...more >>

The text source connection does not show up as an icon in my connection box when i start a new package. How do i get it there? Thanks Chris ...more >>

Hi, I have a user table that's now storing username and password in clear text. I'd like to replace the current password field with a new field that stores the password in hash format. This table is used in a web application. I'll modify my pages to hash the submitted password for compar...more >>

Hi all, We reoved a user from our database, but there were a few DTS jobs that had that user as the owner. Is there a way to change the ownership of the DTS pacakes? TIA, Joe ...more >>

Is there an easy way to move DTS packages between servers ?...more >>

Hi all, In my project we are writing around 150 DTS package. Everytime we make any small modification to any of these DTS package, we have to test all these 150 packages. Testing all teh scenarios for all the 150 packages is time consuming. I would like to automate the testing of the DTS ...more >>

Hi guys, a stupid question, is ETL part of DTS? if it's not, how do I learn it? ...more >>

I got an error while trying to DTS a large text file 13GB large- the error message is "Error at Destination Row Number 20331257. Errors encountered so far in this task is 1. [DBNETLIB][ConnectionRead (recv()).] General Network error. Check your network Documentation." Any suggestions? ...more >>

Does SQL Server store the GUIDs for DTS packages in a table anywhere? Something similar to sysobjects or sysjobs....more >>

I create a DTS package to transfer data between an oracle and a sql2000 servers. When I manually exute the package, it ran through successfully. However, when I schedule it to a job, it failed to run. What could be the problem? thanks...more >>

Hi, I'm trying to import data from dBase files, import is almost success, but occur problem with character encoding in string fields, dBase files are in Ukrainian encoding, and after import in SQL Server I got data with invalid encoding. Any ideas ? How I can select correct encoding for importin...more >>

I have a table that I update each morning via a schedule DTS package. I have another DTS package that does a simple SELECT * on that table and I want to dump it to Excel. The problem is that instead of overwriting Excel each morning, the DTS package appends the new data to the previous day's...more >>

I'm trying to create an easy way for end users to get an excel spreadsheet with data from a SQL Server database. I can easily do this myself with DTS through Enterprise Manager but then I have to be involved each time the user requests updated data. Is this a simple thing to do? I'm using ASP...more >>

I have and ActiveX Script Task that transferes a file over FTP. I then have an ActiveX WorkFlow script that checks to see whether the file has been downloaded. If so I pass DTSStepScriptResult_ExecuteTask or DTSStepScriptResult_DontExecuteTask if there's no file. The problem seems to b...more >>

Here is my requirement. I need to copy the zip file from one domain to another using DTS package. The zip file has a .bak file which then needs to be restored. If anyone has any pointers, please let me know Thanks GS...more >>

I have 4 dts's which transfer data from SQL Server (2000 SP4) to Oracle 8.1.4.7 The distance is large (Europe to Asia) so timing isn't great. However one of the DTS's runs extremely slow, compared to the others for no reason that I can see. Each of the 4 dts's transfer roughly 5-200 rows,...more >>

Is there a way for SQL Server to complete or continue an import even though a row or two may have wrong/invalid data? With MS Access it would just put the violating row in a separate table but still import the main one. With SQL Server 2000 (Pro), if one row is invalid it cancels the operation. ...more >>

Hi i need to put some files from a driectory on a sever across to a live web site on a regular basis. My problem is that the FTP task is set up to fetch files from a web site rather than put them there. does anyone have any suggestions of a way around this ...more >>

I'm working on a little program to document all of my DTS packages using the DTS package library and vb6. I have written the code to enumerate all the DTS packages and step through each one getting the connections and various steps of the ExecuteSQL and Datapump tasks. I'm trying to figure out...more >>

I am trying to create a file from a sql statement that uses for XML. Using the DTS wizard the output is binary. I found the advance properties and changed it, but nothing changed. I am looking for suggestions on how best to do this. I'm a coder so I know I can revert to that, but it woul...more >>

I want to export 3 tables in a SQL database with the table definition and want to then import from this dump into another SQL database where these tables do not exist. The tables are - Cust, MatProd, Plant the database to be exported is - SourcePur and the database these table have to be cr...more >>

Below is the error message I am getting on my dts package - Any help will be appreaciated. Executed as user: BHCS\sqlsrv. DTSRun: Loading... DTSRun: Executing... DTSRun OnStart: DTSStep_DTSExecuteSQLTask_1 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTS...more >>

Hello, I would like to use the DTS object model and VB .NET to create DTS packages to connect to DB2 and export data to CSV and XLS formats as well as import data from CSV or XLS into DB2 tables. Can anyone point me to VB .NET code sample that do this (or something similar)? Regards, ...more >>

I note many occurence of the following error on a Windows 2000 server with SP4, running SQL Server 2000 client: Event Type: Information Event Source: Application Popup Event Category: None Event ID: 26 Date: 10/10/2005 Time: 09:12:06 User: N/A Computer: MyServer Description: Applicati...more >>

I have a series of DTS packages that execute on a scheduled requency. The various jobs import data from multiple data sources. In case the scheduled job should not execute for any given day, the query that gathers information ready for importing into SQL always gathers the last three d...more >>

Dear all I'm using SQL Server 7 + SP4. When i edit a DTS and want to save it , "Invalid transformations detected. Verify and retry your transformations." occurs. anyone overcome this problem ?? thanks ...more >>

Hello, I am trying to do an insert from one db table to another. It works great until a record that is a dup of one that is already in the destination table. (Which I do not want inserted) I do not want the package to fail just not insert the dup record. Thank You For any Help Greg...more >>

I created a few packages for DTS to export on a daily basis. For some reason, they have an error. So I deleted them. But they seem to be still scheduled and running because the error messages keep coming up in my Application log. This is the error I am getting: SQL Server Scheduled Job 'dbo...more >>

I'm trying to author a .dts package that will combine two number fields (in my source MS Access database) to form a date, which would then be stored as a DateTime in my destination SQL Server 2005. I'm using the following expression to create the derived colum: [Day] + "-" + [Month] + "-2...more >>

I'm exporting data from SQL 2000 to sybase 11. the dts is extremly slow (takes over 1 hour for 5000 rows.) the tables in sybase do not have any indexes. what can be done to improve performance ? ...more >>

I am trying to automate upload task at midnight. For this I have create file which generate TAB delimited file, then I create a FTP connection file and thne execute this ftp script for upload the file, but file is still not uploading to FTP server. If I Upload file manually, file uploded s...more >>

Hi Folks, I am pretty new to DTS so I am asking you for some hints. I need to import many Access databases (approx 90) to a new database on the sql server. The design of the new database is COMPLETELY NEW. Those 90 Access databases all share pretty much the same design which was adapted a...more >>

I'm trying to execute a dts package (as file) in AspNet (C#) as per the http://sqldev.net site tut. It works fine when running it in SQL and I get the results as expected. However in AspNet it runs through the code but does not do anything in the dts package itself. ie: stepping through it s...more >>

When importing data from Microsoft Access, DTS automatically uses smalldatetime for the Access data type datetime. How can I change this to automatically get datetime to be used for datetime from Access. Cheers Ferdinand...more >>

Hi all, I have a SQL Server 2000 DTS that ends with an execute process task; it works fine when run from the designer in Enterprise Manager, but not from SQL Server Agent. I have set the instance of SQL Server to run under a domain account with network access and local administrator righ...more >>

Hi peeps, Wondering if anyone can help me. I have numerous SQL databases on a server which was SP4'd and then upgraded to windows 2003. Since then the server has been inaccessible. I get: [Microsoft][ODBC SQL Server Driver] Named Pipes ACCESS DENIED Now I do not know if its windows 200...more >>

Hello, Im learning how to use DTS and currently just reading the MS sites trying to undersand...can some explain why is does not work? Function Main() Dim oPackage Dim oTask 'Dim oStep Dim sSQL Set oPackage = DTSGlobalVariables.Parent sSQL = "Select * From Testing" Set oTas...more >>

Hi All, I'm importing data from an Excel file, it works fine but when data like 32/40 comes it insert null into database, eventhough i declare datatype of column as varchar. I'm insisting for suggestion, is there any way by which we can import single column from excel file into sin...more >>