Rating Thread / Thread Starter	Last Post	Replies	Views
dtsrun.exe hangs before complete Hi, I created a simple DTS package to export data of some tables to Excel file. I want to execute it with dtsrun.exe but it hangs... ryoko	06-13-2005 01:35 PM ryoko	2	108
Import of text file using ActiveX.... New guy here - basic situation is as follows. Trying to import text file into SQL Server. The file is sometimes empty so I want to skip the... unc27932@yahoo.com	06-13-2005 01:10 PM Allan Mitchell	2	113
Good source for getting icons for custom tasks/transforms Can somebody please point me some good web sites to get the .ico files for the custom tasks/transforms. Thanks Karen karenmiddleol@yahoo.com	06-13-2005 09:36 AM karenmiddleol@yahoo.com	0	61
Date conversion in DTS Hi, I have created a DTS package for reading data from Excel sheet and copying them to SQL Server database. Overall it works fine. But I have a... Harish Mohanbabu	06-13-2005 09:21 AM PaulaPompey	3	80
OLEDBProviderInfos collection vs Connections I have two questions: 1) Why aren't the available DTS providers (connection Icons in Designer) listed in the OLEDBProviderInfos collection of the... toryb	06-13-2005 08:41 AM toryb	0	58
Old DTS saves Potential newbie question... I have one package that runs inside another one. I have noticed that I have to update which version of the package I... Rob Blij	06-13-2005 07:25 AM Darren Green	2	57
Custom DTS Task does not persist checkbox values I have defined a DTS custom task with the following declarations for the DTS Custom Task class 'Required for CustomTask Implements... karenmiddleol@yahoo.com	06-13-2005 07:22 AM Darren Green	1	55
Importing Data From Excel File Hi Everyone Im Trying To Import Data From Excel File To Table. This Table Have 2 Fileds Only & They r Both Primary Key & With Relation to Another... Mariame	06-13-2005 03:55 AM PaulaPompey	1	64
Sql Server task failing for parameters Dear all, When I am building a sql server task I am not be able to put a global variable inside a dynamic command. Look at this: SET @bcpCommand=... Enric	06-13-2005 01:01 AM Allan Mitchell	1	57
Driver Error when running DTS directly on the server Hello everyone, I have just created some DTS package wich pump data from Visual FoxPro database to SQL Server 2000. Everything works fine when I... Dominic Feron	06-13-2005 12:57 AM Allan Mitchell	1	63
Empty text file(destination) problem I'm having intermittent problems with a DTS package randomly generating empty files. My package is actually split up into 4 packages, due to size,... Eric	06-13-2005 12:52 AM Allan Mitchell	3	64
DTS Import from Excel Name Range I'm trying to import a name range from an excel file. I call the DTS package via VBA and it captures the information I want perfectly. ... Jason Mancuso via SQLMonster.com	06-13-2005 12:49 AM Allan Mitchell	1	61
Re: executing dts files from asp.net Where is the file that has the package? Security? The box from which you are executing has the DTS dlls? -- Allan Mitchell MCSE,MCDBA,... Allan Mitchell	06-13-2005 12:39 AM Allan Mitchell	0	63
Database Copy Wizard for large database Is it adequate to use the Database Copy Wizard for large databases. The database is about 20 GB GMG	06-12-2005 10:18 PM Michael Cheng [MSFT]	4	58
Copy Database Wizard Fails to Copy Files Running SQL Server 2000 SP3a on Win2000 Server (fully patched). Trying to get a simple example to work for copying a Test DB (which has one simple... Robert	06-11-2005 01:44 PM Kedzior	5	72
Error Description: The DTS host failed to load or save the packag I am recieve this error when trying to design some of the packages on the SQL 2000 box running service pack 3. The diagram appears, but when trying... Troy	06-10-2005 05:23 PM Troy	2	82
Manual replication through DTS We are using a dynamically created DTS package to do a complete push replication from our production system to our public-facing website. Recently,... Jon Choy	06-10-2005 09:37 AM Jon Choy	8	73
SQL 2005 DTS - Packages Hello: I have 1-day experence with SQL Server 2005. So bear with my ignorance. I created a Project and several DTS Packages in it using BI... vvenk	06-10-2005 03:54 AM Darren Green	1	75
Question about deploying DTS objects (COM, DTSRUN.exe, etc.). Hello all! I have a series of file-based DTS packages that I want to execute from our web servers, and I have a couple of questions about the... John Peterson	06-10-2005 12:08 AM Allan Mitchell	3	57
it all started on 5/27.... Good morning folks, I am at my wits end and have turned to you so that I can keep some of the remaining hair on my head. This is going to be a long... Tony	06-09-2005 03:26 PM Ilya Margolin	5	55
Perl Support for Scheduled DTS I scheduled a DTS package(first time I've done this) on our SQL server. The job history says it fails on the first step, which is a custom perl... shumaker@cs.fsu.edu	06-09-2005 02:15 PM shumaker@cs.fsu.edu	0	57
Excel inmport troouble with numeric/test data I'm trying to import data from Excel 2000 file with DTS in MSSql2000. I keep getting NULL values during import. I have been using this post... Mike	06-09-2005 01:29 PM Mike	2	73
Help - DTS Image data to an external file. I need to create a table and populate its data, including about 100 icon files stored in IMAGE columns. This will be part of an install that creates... Robert Porter	06-09-2005 01:08 PM Allan Mitchell	3	67
regex in DTS I use either of these two patterns 1)"d\d\d\d\d\d\d\d\d\d" 2)""d{10}" to regex a 10 digit number but it never pass the test method (always... J-T	06-09-2005 12:30 PM J-T	2	63
DTS install We are using SQL v8 from the newest version of ACT! (v2005). We'd like to use DTS to transfer data in and out of ACT! to an MS SQL server. The ACT... Deane	06-09-2005 11:34 AM Darren Green	1	69
2005-DTS: Editing and running DTS Package Hello: I just installed 2005 Beta 2 and I have been trying to understand DTS. I was able to create a DTS package using the wizard and saving it.... vvenk	06-08-2005 06:35 PM Allan Mitchell	1	62
error: ActiveX Scripting encountered a Run Time error... Hi All, I have created a DTS package with an ActiveX Script calling the CDO/MAPI object: dim oMapi Set oMapi = GetObject("", "MAPI.Session") and I... OutlookNewbieDev	06-08-2005 04:41 PM OutlookNewbieDev	4	65
DTS Package Relative Priority Class Affected By SQL Server Priority Hi, Is a DTS package's Relative Priority Class affected by boosting the SQL Server Process? Thanks, Bryan BDB	06-08-2005 03:20 PM BDB	0	75
date column hi in my table date value is 2005-05-30 16:40:00 In select statement, i want to compare with 05/30/2005 can anyone tell me how to use date... Kalyan	06-08-2005 03:10 PM JFB	1	75
How to check row existence while Importing data using ActiveX Scri Hi All, I am trying to make an Access Project using SQL Server 2000 DTS functionalities. I have to import selective columns from a table of dbase5... Vishal Sood	06-08-2005 03:03 PM Allan Mitchell	5	58
Export to text Can I export a query to text file? I can't figure out how to make the destination. The data pump errors because there is no transformation and... M D	06-08-2005 02:35 PM M D	2	71
Using XML with DTSs Hi, Is there any way to manage (import or export) XML using DTSs?. I know I can use TXT files, Excel files, etc (including HTML ¿?),but is there any... Lucas	06-08-2005 12:54 PM Lucas	0	80
Login failed for user '(null)' - Not associated with a trusted connection We had a DTS package that was working fine until yesterday and since today it does not work and we get the following error message: Login failed ... karenmiddleol@yahoo.com	06-08-2005 11:58 AM Simon Worth	3	80
DTS Dynamic Properties and INI File Does anyone know where/how to change the path and filename used by the Dynamic Properties task when reading an INI file. I would like to... dm4714	06-08-2005 11:26 AM JFB	1	62
HELP!!! Exectuing DTS from ASP Hello, I have a very big problem, and hope someone can help me... IÃ¡m calling a DTS from an ASP, these seem to work pretty fine when I have very... Guido Schauwecker	06-08-2005 10:52 AM JFB	1	71
import non-existing data only Hi, I am a newbie at sql server. Can someone please tell me if there is anyway to only import data from source database that aren't already existed... Donna	06-08-2005 10:42 AM Narayana Vyas Kondreddi	1	48
DTS error when the task is scheduled on the server! Hello everyone, I was asked to create some DTS package that transfer data from a Foxpro database to SQL Server, Everything works fine when I... Dominic Feron	06-08-2005 09:36 AM Dominic Feron	2	89
error using MAPI.Session in DTS Hi, I am using an ActiveX Script Task to work with the CDO/MAPI object from DTS. When I execute the package it errors out with a "Run Time error"... OutlookNewbieDev	06-08-2005 09:36 AM OutlookNewbieDev	0	60
DTS Error Log file Hi, How can we see the DTS error log file after executing the DTS package? Thanks in advance Regards Satish Satish	06-08-2005 09:24 AM Ilya Margolin	1	73
Help importing from text file via DTS Hi, I have the foll TEXT file id doc name 0 1 test 0 2 test2 I need to import it into a table with the same columns id,doc,name but I need... Chris	06-08-2005 04:22 AM Chris	6	77
DTS limiting file size in export Hi I need to export a table as a one or more text files with the files being limited in size. The only solution I can think of is to use activex... Jonathan Crawford	06-08-2005 01:00 AM Jonathan Crawford	0	57
DTS 2000 Data pump issue Deadlock? ( 1 2 ) Hello All, I have run into a small issue with the Data Pump Task (or Data transformation Task). The issue is the data pump appears to be creating a... Myles	06-08-2005 12:49 AM Myles	10	126
Import Flat file Data into Sql Server with Transaction I have a text file with 300 rows and try to transform into sql server 2000 using DTS. Suppose i got a integrity in 250 rows. I want to roll back the... guna_selvas@yahoo.com	06-07-2005 12:40 PM Allan Mitchell	3	70
Integrity Check using DTS I have text file as source and destination will be sql server. I have a check a source column satisfied the given condition ie.,DTSSource("Col005") >... guna_selvas@yahoo.com	06-07-2005 12:39 PM Allan Mitchell	1	57
dts integrity question I have created a custom dts package that transfers about 80 tables to another db with different column names table name etc My question is I went... Rob Blij	06-07-2005 12:37 PM Allan Mitchell	1	76
How could I use a LookUp Query in a DataTransform Task to reach my goal? I'm interested in doing the following thing: I have this stored procedure: CREATE PROCEDURE usp_sequence @idseq int OUTPUT AS BEGIN TRAN SET @idseq... icebold54@hotmail.com	06-07-2005 01:52 AM icebold54@hotmail.com	4	76
Newbie: Update From Excel I am a newbie at SQL Server, but I do have a little experience from Coldfusion. Here's my Question. We have a database for our business. We sell... Cavan Vannice	06-06-2005 05:19 PM Allan Mitchell	7	61
Login Transfer error Hi all, I have created a login transfer task from My production server to my standby backup server to transer logins. This task was working fine... Sam	06-06-2005 03:26 PM Sam	0	72
DTS from Oracle. Global datatype transformation spec possible? I'm using DTS to import an Oracle DB to SQL server. Although I know I can specify a non-default datatype transformation on a column-by-column basis,... Kathy	06-06-2005 02:33 PM Allan Mitchell	1	56
What's the best way Hi All, Let me start by saying I have 0, nada, zilch, zip experience with DTS, so be gentle ;-) We have this guy who, as part of his job, maintains... BW	06-06-2005 02:28 PM Bill Reed	2	62

Page 126 of 258

126

Forum Tools	Search this Forum
Mark This Forum Read View Parent Forum	Search this Forum : Advanced Search

	New posts		Hot thread with new posts
	No new posts		Hot thread with no new posts
	Thread is closed

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off