Rating Thread / Thread Starter	Last Post	Replies	Views
Error 429 using DTS in VB6 Hi, Any pointers on identifying the Error 429 (can't create ActiveX Object) in my tiny VB app that simply uses a DTS object to remotely upload... Michael D. Murphy	08-06-2003 03:03 PM Darren Green	2	105
DTS Package files under stored procedure - only. I apologize for the dual posting in microsoft.public.sqlserver, now... I have a DTS package that imports a text file from a UNC path. Right... Andrew	08-06-2003 02:43 PM Darren Green	3	65
error -2147467259 (80004005) when schedule a DTS ( 1 2 ) Ok Darren. The DTS exports a table on a Excel file. First it rename the file Excel on the filesystem (and it goes fine, so the proxi account have... masfer	08-06-2003 02:28 PM Darren Green	10	122
vb dts application i'm 2 days late on having this working and still don't have an answer... here is the call: SetConnections(oPackage.Steps.Item, oConnection)... trint smith	08-06-2003 02:02 PM Allan Mitchell	1	59
Re: newbie duplicate delete dts question In article <041a01c35c41$7f43b840$a301280a (AT) phx (DOT) gbl>, Geoffrey Baker <gbaker (AT) gwi (DOT) net> writes Whilst I've tried running a... Darren Green	08-06-2003 01:41 PM Darren Green	0	59
Execute Package with Input Parameter I major help...I've got a table that has invoice information. As a Nightly process (only on weekdays) - we need to export the data to an Excel or... Andrew	08-06-2003 11:49 AM Andrew	2	80
Converting PK to identitiy? Derek, There are a couple of ways to do this. First, I would build the tables in SQL(Tables1) with Identity and a PK on that value, if that is what... MG	08-06-2003 10:48 AM mg	2	48
Ftp task changes format? I have a file on an ftp server, that I am retrieve with a dts ftp task. When I ftp it with the ws_ftp application the file looks great. When I ftp... Jeff Langston	08-06-2003 09:04 AM Jeff Langston	0	58
Re: how to rename a file in ActiveX ? I do it as the last step of this (included in a Move) Looping, Importing and... Allan Mitchell	08-06-2003 08:53 AM Allan Mitchell	0	59
Executing DTS package Hi All, I have a sample on how to run a DTS package from a .BAT file, my problem is that I do not know how to get the DTS name to run it Here is... Julio Gonzalez	08-06-2003 06:40 AM Darren Green	6	115
Re: Changing properties of a Custom Task If I read the question properly you can do this with the object model. Something like this Changing the DTS Send Mail... Allan Mitchell	08-06-2003 06:17 AM Allan Mitchell	0	51
Error Description:Unable to create SQL-DMO objects. Hi Guys, I'm getting the below message, any ideas? Error Source: Microsoft Data Transformation Services (DTS) Package Error Description:Unable to... Richard	08-06-2003 05:14 AM Allan Mitchell	1	74
Oracle ans SQL Server Goog morning, I would like to know how I can link an Oracle Server to a SQL Server via DTS Packages. Is it possible ? Thanks for your answers Julien Julien	08-06-2003 04:34 AM Julien	2	71
DTS bulk copy with big files Dear all, I'm running a DTS-Package, which transfers tables from one SQL Server 2000 to another one. In one table there is an image-column. If one... Matthias Merz	08-06-2003 02:19 AM Matthias Merz	0	59
importing data I'm trying to import data from a test server to a production server. I'm using a local UID and password to access the testing server but the database... mar	08-06-2003 01:38 AM Allan Mitchell	1	64
dBase, Jet 4 sp7 & Win 2k sp4 Does anyone know of a problem with the MS Jet 4 Service Pack 7 (4.00.6807.0) that comes with Windows 2000 Server Service Pack 4 when running SQL... Scott Taylor	08-06-2003 01:26 AM Scott Taylor	0	66
Using Global parameter to extract data from non SQL Server DBs Certainly my driver is 4.00.6200.00 22/7/2002 -- ---------------------------- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com Julie	08-06-2003 01:22 AM Allan Mitchell	4	88
DTS Error Saving Package Thanks for the tip, mate, but I'm not using any global variables. Any other possibilities? Paulo Weiler	08-05-2003 03:56 PM Darren Green	2	50
Re: Transform Data/Parameter (?) syntax error I do not have Win2003 here but what is the statement you are trying in the Source ? -- ---------------------------- Allan Mitchell (Microsoft SQL... Allan Mitchell	08-05-2003 03:21 PM Allan Mitchell	4	60
moving/copying diagram from one sql db to another Hello, I have not yet been able to get my diagram from one database to another. I found the Microsoft Knowledge Base Article - 320125, which... Rick	08-05-2003 02:45 PM Rick	0	68
OLE DB Export limited to 6993 rows Why, when I export table with 100,000 rows is it limited to 6993 rows? There is nothing in my SELECT or if using the Wizard to limit the rows output.... G Stark	08-05-2003 02:03 PM Allan Mitchell	1	68
importing data I'm trying to import data from a test server to a production server. I'm using a local UID and password to access the testing server but the database... mar	08-05-2003 01:58 PM mar	0	54
Paradox to SQL 2000 Hi I'm trying to import into sql 2000 from paradox using dts I have the import function all figured out but for some reason the delete command... Microsoft	08-05-2003 11:18 AM Microsoft	0	59
-2147221504 error Allan Mitchell suggesting to re-register DTS and SQLDMO dlls. I'm going to try. Albert Albert	08-05-2003 10:02 AM Albert	0	107
execute a bat file on another server I have a set of DTS packages I have built to transfer data from MSSQL 7.0 tables to a Sybase 12.0 tables. Some are quite large and the inserts could... pegnmil	08-05-2003 08:51 AM pegnmil	0	47
Getting detailed error info from Multiphase Data Pump As part of my DTS package, I am using a Multiphase Data Pump. When an insert or transform error occurs I am recording the error details in the... Dirc	08-05-2003 05:33 AM Dirc	1	76
Import from Ms access with relationships While importing from ms access to sql server 7.0 table relationships are not coming in sql server, but table data are imported properly. how to get... lakshminarasimhan	08-05-2003 02:01 AM Allan Mitchell	1	57
OpenRowSet Hello All, I am attempting to access a DTS Package stored on SQL server using the OpenRowSet command, however every time I attempt this I am... Brian	08-05-2003 01:39 AM Allan Mitchell	1	73
Re: Error is still existed So you're moving data between Sybase and SQL Server using DTS through .Net If you can execute the same package from the same PC using VB then it... Allan Mitchell	08-05-2003 01:32 AM Allan Mitchell	0	56
DTS to Excel I have written a dts package to export data from a table to excel. However, the data is being appended. Is there a property which I can set to... Lynn	08-05-2003 01:27 AM Allan Mitchell	1	75
Datetime error when importing from csv I'm having troubles importing date fields from a csv. I've tried a variety of ways, but to no avail. I keep receiving errors to the effect... Jeff Borden	08-05-2003 01:20 AM Allan Mitchell	1	74
SQL2K DTS Transform converts special characters to invalid characters I've encountered an issue with SQL2K (SP3) DTS Transform where nordic characters like "ö and ñ" when transfered from a source of varchar to a... Carlo	08-04-2003 06:03 PM Carlo	0	66
CONVERT I created a harvest routine but got an error "...The number of failing rows exceeds the max specified. Transform copy 'DTSTransofmration_ Conversion... Mary	08-04-2003 05:36 PM Nate Russell	1	97
Create Destination Table based on text file Is there a way in DTS to create a destination table based upon the format of a text file source? In the transform data task, you can use the Create... Susan	08-04-2003 04:38 PM Darren Green	1	70
An error when programming DTS in Sybase Hi, I try to program DTS using .net(C#) and my DBMS is Sybase 12, my code segment is below: when I run the app, it gives an exception "A Dll... Jason Chen	08-04-2003 05:12 AM Allan Mitchell	1	61
export to text problem On SQL Server 2000 sp3, on Windows 2000. I'm running a simple table-to-textfile DTS job (a single varchar field), and it's running fine EXCEPT that... J O Holloway	08-04-2003 01:09 AM Allan Mitchell	1	72
Execute a DTS package from within a vbs I have a vbs running every night that copies user log files into one txt file so that the one txt file can be imported into the database with a DTS... DRE	08-03-2003 02:35 PM Allan Mitchell	1	75
help with commit in DTS I have DTS with 3 steps Step 1 Execute SQL insert into table A Step 2 Execute SQL update table B Step 3 Execute SQL delete from table C if Any... Alex	08-03-2003 02:26 PM Allan Mitchell	1	71
Creating a file in DTS A very basic question ( I think....) I am new to DTS. I want to create a simple .xls(excel) file with a specific name using my DTS package How can... JK	08-03-2003 02:17 PM Allan Mitchell	2	83
Re: Calling DTS package Thanks Darren "Darren Green" <darren.green (AT) reply-to-newsgroup-only (DOT) uk.com> wrote in message news:jl2MArAAZPL$EwLh (AT) sqldts (DOT) com... Nick Vallance	08-03-2003 08:46 AM Nick Vallance	0	62
Help! Insert or Update rows in DTS (DDQ?) Ok, I know I can't be the only one who wants a well-defined way to do this. I have a set of records that will need to be inserted if they don't... mhavens	08-02-2003 03:39 PM Narayana Vyas Kondreddi	1	65
How to put today's DATE in filename? I'm using DTS to export data to a csv file. This will be scheduled to create a new file every day. How do I name each file with today's date? eg:... les	08-02-2003 08:59 AM les	5	84
DTS Process Flow I'm trying to create a local package that will back a set of SQL Server tables up to a local Access file on a regular basis. The goal is to have... Bryan O'Malley	08-01-2003 09:25 PM Bryan O'Malley	2	46
Editing a System Stored Procedure I'm having difficulty editing a stored procedure as described in: http://www.sqldts.com/default.aspx?6,105,212,0,0 I'm sa, I've checked "Allow... CR	08-01-2003 12:22 PM CR	1	61
Paralell execution of a DTS Package Hi everybody, Is posible to execute at the same time 2 SQL Agent Jobs that runs the same DTS package in the same server? I'm try to load a DWH with... Javier	08-01-2003 11:20 AM Javier	0	70
Connections Tab of Server Properties In the "Connections" tab in Server Properties, there is a checkbox for "Allow other SQL Servers to connect remotely to this SQL Server using... CR	08-01-2003 08:14 AM CR	0	59
DTS package with variable Hi, I want to create a DTS package which can accept parameters and only import / export data based on the value of the parameter. can anyone please... Ram	08-01-2003 07:13 AM Jamie Thomson	2	56
Importing Access data into SQL Server I have created a transform data task that inserts rows in SQL Server from Microsoft Access 2002. The Access source table has an Autonumber field... Scott Adams	08-01-2003 12:13 AM Allan Mitchell	1	41
file transfer over the network Hi, anyone can help me with this problem: I tried to create a DTS to copy sql server objects from one server to another. But at the end of... July	07-31-2003 07:17 PM July	0	46
Error: Code Execution Exception I get it when trying to open a package. If you get it resolves, please post a followup. Thanks. Paulo Weiler wrote: Paulo Weiler	07-31-2003 05:55 PM KevCash	2	51

Page 249 of 257

249

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