Rating Thread / Thread Starter	Last Post	Replies	Views
Oracle --> SQL DTS issue Hi all, I am accessing a Oracle Database for DTS using MS ODBC driver. The simple queries can easily provide the data required over the DTS, however... abhishek	05-24-2005 12:42 AM abhishek	0	79
Last DTSRun OnProgress hi, I have a package that imports data from Informix 9.X to SQL Server 2000. I found the transformation always stop at the last DTSRun OnProgress for... steffi	05-24-2005 12:40 AM Allan Mitchell	3	89
DTS performance vs T-SQL Hi, Is there any differences in performance between DTS and T-SQL when copying tables from one db to another without any transforms? I'd like to... knut.eldhuset@gmail.com	05-23-2005 07:10 PM Tom Moreau	3	79
OLEDB driver for Informix Anyone where I can download or purchase an OLEDB driver for Informix? Thanks! Ken	05-23-2005 06:58 PM Sue Hoegemeier	1	71
Kill job that is executing endlessly I have a DTS package that is scheduled to pull read-only data from an Informix server every 10 minutes. When it works, it takes less than... Mark	05-23-2005 03:36 PM JT	3	104
Passing a query result between two separate SQL server in DTS Dear Sir/Madam, In a DTS connection on a SQL server say 'A", I am doing a select max(rec_id) as 'nextno' from table in a database resided in SQL... Wingman	05-23-2005 02:33 PM Wingman	7	80
DTSRun.exe - Dr. Watson I received a Dr. Watson error that I need help with. Any ideas that could help me debug this issue, is greatly appreciated. Microsoft (R) Windows... Richard	05-23-2005 01:33 PM Richard	0	169
Informix to SQL I'm trying to create a dts package to load data from Informix to SQL. I created two connections - one for SQL and one for Informix (IBM OLEDB... Ken	05-23-2005 12:28 PM Ilya Margolin	3	82
Reassigning DTS packages from one SS2K server to another Hi, We have a situation here where a consultant has come in and developed approximately 45 complex DTS packages on the development server (lets say... Leigh Gardner	05-23-2005 12:13 PM Darren Green	1	76
process cubes via DTS on web server Hi All, How I can process my cubes via DTS on my web server? My OLAP and OLTP databases is on a database server. I can run DTS package if no... Joel Leong	05-23-2005 10:47 AM Darren Green	1	77
DTS percentcomplete hi Is there any way to changes the percentcomplete present in Onprogress event via the DTS designer ? teh percent complete always shows 0, how can... abhinav75 sharma via SQLMonster.com	05-21-2005 03:53 AM Darren Green	1	92
Why does an Activex step cause package to fail when it fails? I have a dts package which needs to branch depending on the existence of a certain text file. Currently I have an Activex VBscript step which... Snake	05-20-2005 04:27 PM Snake	4	74
Specifying DTS Data Source at Run-Time Set up a DTS package to import data into SQL Server from Excel. I would like an end user to execute the package, even right from Enterprise Manager,... Brett Ossman	05-20-2005 01:21 PM Brett Ossman	2	70
URGENT URGENT... Hi, I need help in retrieving some data from our server which got deleted accidentally while exporting a stored procedure. What happened is I forgot... MightyJoeYoung	05-20-2005 12:42 PM Kevin3NF	3	69
DTS package for remote internet SQL Server I have a problem with a DTS package which needs to connect to a remote, ISP hosted SQL Server and backup the live data to backup databases on our... karl.rhodes@keywave.com	05-20-2005 12:38 PM Allan Mitchell	2	70
Error using a Dharma ODBC driver I work at a hospital that has an ICU program called CareVue that has an AllBase Database. We are attempting to import data from the database into... Ben Jones	05-20-2005 09:28 AM Ben Jones	0	95
Text File with Fixed field length greater than 4096 Hi all I am trying to import a text file with with a Fixed field length greater than 4096 characters. In the connection properties I am not able to... Frank Uray	05-20-2005 08:08 AM Helge C. Rutz	1	77
Howto get data from Oracle (in a proc) to SQL Hi all, I am accessing a Oracle Database for DTS using MS ODBC driver. The simple queries can easily provide the data required over the DTS, however... abhishek	05-20-2005 04:33 AM abhishek	0	70
DTS package fails: [DBNETLIB]..... SQL Server is running on my PC. The server name is 'ASPEN'. When I create a DTS package to export a local database to our live site, I must... Robin Handler via SQLMonster.com	05-20-2005 01:33 AM Helge C. Rutz	1	84
Dynamic DTS Task Challenge I have a DTS Task that has the following: * Dynamic Property * SQL Task (Truncate a table in SQL) * Connection1 (Input CSV file) * Connection2... dm4714	05-19-2005 06:45 PM Rodney Mullins	3	79
DTSTaskExecResult_Success i am executing Following DECLARE @res int EXEC @res=Exec Admin_Fixes_Process_Duplicates_Referrals SELECT @res in Execute SQL Task Kalyan	05-19-2005 06:21 PM Darren Green	2	173
dts + execute task very urgent i am calling stored procedure in DTS i want to check on success or failure if stored proecedure failed i will send out email othrewise go to next... Kalyan	05-19-2005 06:14 PM Darren Green	1	66
Packaging DTS Components with .NET Application Hello all I have a small app that does some file exporting from an SQL server. On this SQL server a DTS package is run to draw in data from a... John Wildes	05-19-2005 01:53 PM Darren Green	3	82
EXISTS Versus IN Is there any performance differences between the use of EXISTS and IN within queries? Robert Hamilton	05-19-2005 01:52 PM Allan Mitchell	1	87
Error When Opening Package Hi All, I copied a package from server to another and now I can not open it on the test server...I get the following error: Invalid class... Michelle	05-19-2005 01:50 PM Darren Green	2	77
Problem Executing DTS Task from VB Hi, Running DTS from VB is new to me, so apologies for the newbie question. I have a DTS package which runs problem free in MMC. I wanted to... Jim Fox	05-19-2005 09:49 AM Darren Green	7	113
Repeating 3 Datapump actions between the same datasource/destinati I need to repeatedly call 3 stored procedures (only the first 2 stored procedure need to be called repeatedly) on a Sybase ASE 11 database to... Patrick	05-19-2005 02:53 AM Michael Cheng [MSFT]	3	91
Oracle Connections hangs when schedule I have a simple DTS to pull data from Oracle 8i table to SQL 7.0 table. This runs without any issues when it execute intractively but when it... Podi	05-18-2005 05:41 PM Podi	0	90
Generating one table with a terabyte of data ( 1 2 ) Hi All, I need ideas on how to improve a process that can generate a terabyte of data in a week. Our company produces software that analyzes code... lee	05-18-2005 05:09 PM Jim Vierra	15	186
GetExecutionErrorInfo fails...help Hello, I know that GetExecutionErrorInfo doesn't work when called from within a VB script. So I downloaded the zip file that the ActiveXHelper COM... Tom P	05-18-2005 03:17 PM Darren Green	1	154
GetExecutionErrorInfo Method Fails when executing ( 1 2 ) Hi, I am trying to determine if any of the step in package failed. I am executing a package from within an ActiveX script. The execution of... fsanchez	05-18-2005 03:15 PM Darren Green	10	333
assign password Does anyone know if there is a way to assign an owner and user password to an existing DTS Package without having to do a saveas and give it a... Mike Read	05-18-2005 02:57 PM Darren Green	1	86
setting a alert on time out of a schedulted dts package what i want to do is a follows: 1. schedule a DTS package with timeout.but should not terminate the job. 2. when it timesout i want to send out a... kamal	05-18-2005 11:43 AM kamal	2	75
help on sp_help_job does nay one have a idea which tables r used by this sp kamal	05-18-2005 11:43 AM Helge C. Rutz	1	83
Error: The selected package cannot be opened Hi, I am opening DTS package. I am getting errors: Error Description: The DTS host failed to load or save the package properly. The selected... Andrej	05-18-2005 09:48 AM Andrej	0	70
Error: The selected package cannot be opened Hi, I am opening DTS package. I am getting errors: Error Description: The DTS host failed to load or save the package properly. The selected... Andrej	05-18-2005 09:47 AM Andrej	0	88
Error: The selected package cannot be opened Hi, I am opening DTS package. I am getting errors: Error Description: The DTS host failed to load or save the package properly. The selected... Andrej	05-18-2005 09:19 AM Andrej	0	93
Error 208 from Copy Objects task Hello all... I have inherited a DTS package that includes a Copy SQL Server Objects task. This task copies all objects and data and has been around... Kevin3NF	05-18-2005 08:51 AM Kevin3NF	0	103
Execute Package Task error I have encountered this situation a number of times and wanted to see if anyone else has run into it. I have a few packages that primarily call... LP	05-18-2005 07:49 AM LP	2	85
Error While Accessing Global Temporary Table inside a DTS Package I am creating a global temporary table by calling a stored procedure in one of the steps in a DTS package. In another step, I am trying to fetch... Sevugan	05-18-2005 07:38 AM Helge C. Rutz	8	89
Upgrading DTSRun.exe from SQL Server 7.0 to SQL Server 2000 On my development DTS server, running Windows 2000 server, I have -d:\Program files\DTSUtilities\Binn\DTSRun.exe, which has a version... Patrick	05-18-2005 03:14 AM Sophie Guo [MSFT]	2	82
Scheduled DTS package job fails? I created a package on our dev server and can manually execute it OK from Enterprise Manager, but when I schedule it, the job fails. I'm having... Dave	05-17-2005 06:08 PM Sue Hoegemeier	1	87
API in VB code is rolling back SQL import but wizard does not I have a DTS package in visual basic that was created via the DTS wizard and it rolls back or empties the SQL table when a laod failure is... ezelasky@hotmail.com	05-17-2005 06:07 PM Darren Green	3	78
DTS Package Import I have a .dts file that I would like to open/setup within my SQL Server 2000 server. Does anyone know of a way I can insert the DTS package without... dm4714	05-17-2005 04:12 PM Helge C. Rutz	6	114
passing DTS global variables into VB Script? I have some Global Variables i've defined within a DTS package that I want to pass into an ActiveX (VB Script) task within the same package. Anybody... Tom P	05-17-2005 04:06 PM Tom P	2	62
Executing Jobs via a SQL Statement Does anyone know of a way to execute a job from a SQL Statement? JEH	05-17-2005 01:55 PM Allan Mitchell	2	64
DTS Failed Hi experts, Hope someone can guide me on this problem. I'm trying to import mytext1.txt into myDB table mytable1. During the import process I... GW	05-17-2005 01:51 PM Allan Mitchell	2	75
SQLXML Template-Import XML into DTS Package I am working on a project which requires that all data be transported in XML and fed directly into DTS. I have created parameterized templates... Rob	05-17-2005 01:13 PM Rob	0	71
Please HELP! text import problems. I have been having difficulties for many months now when importing text data that is exported from SAP then FTP's from a UNIX server to my SQL... Gary	05-17-2005 12:40 PM Gary	2	64
DTS ERROR 8004206A hi, There're 11 subpackages in a main package.Every subpackage will first delete ( by executing a store procedure) sql server data and then... steffi	05-17-2005 10:43 AM Ilya Margolin	1	148

Page 129 of 258

129

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