dbTalk Databases Forums  

Sponsored Links

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Discuss in the microsoft.public.sqlserver.dts forum.

Post New Thread
Threads in Forum : microsoft.public.sqlserver.dts Forum Tools
  Rating Thread / Thread Starter Last Post Reverse Sort Order    Replies         Views     
Hey all, I'm currently using a shopping cart software called .netCart, which is in ASP.NET and VB. I have been trying to import my local "fully...
09-26-2004 04:19 AM
Allan Mitchell Go to last post
3 82
I have some data that I would like to use DTS to import to a MS SQL Server table. Two of the fields contain packed-decimal data. Does an easy way...
Mike Vanecek
09-26-2004 02:06 AM
Allan Mitchell Go to last post
1 117
is there some performance considerations when using execute sql task - is it better to use a large stored procedure compared to 10-15 execute sql...
Michael Vardinghus
09-25-2004 01:51 PM
Allan Mitchell Go to last post
1 73
I used the Copy SQL-Server Objects Task to copy tables and views from a production server to a reporting server. On the production database I...
09-25-2004 06:15 AM
Allan Mitchell Go to last post
5 81
When I run sp_who2 I am seeing about a dozen spid's using the sa login running in the background and the command is Task Manager. Does anyone know...
09-25-2004 06:14 AM
Allan Mitchell Go to last post
5 141
Our company bought a new AS/400. I need change the data source from OLd to New AS/400. But the DTS don't like it, if it change the host table or...
09-25-2004 06:13 AM
Allan Mitchell Go to last post
3 106
I need to merge a table in an Access database with an existing table in our SQL Server 2000 database. The structure of the tables is the same. I...
Rick Young
09-25-2004 02:50 AM
Allan Mitchell Go to last post
1 92
Hello: I am working on a VB.NET program that allows me to copy whatever DTS package or packages from one server to another. I am using the...
09-25-2004 02:41 AM
Allan Mitchell Go to last post
1 89
I'd like to get a string stored in a SQL table directly into an ActiveX Script. (More specifically, I am retrieving the name of a file which was...
George Morton
09-25-2004 02:33 AM
Allan Mitchell Go to last post
2 107
Is there a good reference to the DTS APIs besides the online books and the VB generated code in the wizard? I think I am going to be asked to write...
09-25-2004 02:27 AM
Allan Mitchell Go to last post
1 83
Hi All, I have a DTS package that queries a table and generates an Excel file. The excel file is saved on a remote file server. When I execute the...
09-24-2004 04:42 PM
Peter A. Schott Go to last post
3 73
I know I have touched on this before, is it possible to import records using DTS from the sequel server that will bring the table into excel and when...
09-24-2004 01:28 PM
Mike Anderson Go to last post
2 107
Can anyone tell me the difference between "execute" on a package versus "dtsrun" command line? I have a package that runs fine by right clicking and...
09-24-2004 11:18 AM
Peter A. Schott Go to last post
1 111
I am looking to import 7million rows worth of data from a flat text file. all the rows seem to be copied over but they are not arranged like they are...
09-24-2004 09:49 AM
rob Go to last post
3 77
Hi I use bulk insert to load data from a csv file to sql server db. The character data in the file is surrounded with quotes. In the bulk task...
09-24-2004 08:25 AM
Allan Mitchell Go to last post
1 97
Hi! If I try to import a table in sql server 2000 sp3 enterprise manager, choosing my access 2000 database as source and my sql server as...
09-24-2004 08:11 AM
Allan Mitchell Go to last post
3 92
I have a problem with a duplicate key. The input to the datapump is a large txt file, the output is a SQL table with primary keys defined. I'd like...
George Morton
09-24-2004 08:05 AM
Ilya Margolin Go to last post
2 106
I currently run a DTS packages to import data from an SQL server into an excel worksheet. It is set up to run the data every night, but the problem...
09-24-2004 08:03 AM
Allan Mitchell Go to last post
4 113
Message that Allan Mitchell sent: my message below. Question will this allow the new records only each time we run it at night, that is what I want,...
09-24-2004 07:49 AM
Allan Mitchell Go to last post
1 81
Hi! I have a problem regarding a DTS package. The package is residing on a machine that will be formated in near future. On that machine I have a...
09-24-2004 05:03 AM
Henning Go to last post
2 340
What would cause a DTS package when executed to change a SQL Server Alias from NamedPipes to TCP/IP? Thanks, Mark P.
Mark P.
09-24-2004 04:28 AM
Allan Mitchell Go to last post
1 73
Hi group, I need to skip certain tasks in a DTS package based on some condition (the presence of certain rows in a database table). What would be...
Jens Weiermann
09-24-2004 04:25 AM
Allan Mitchell Go to last post
1 78
I was using a linked server to do this. As long as your file has a PK you can use to just grab new rows, you should be in good shape. I had to turn...
Peter A. Schott
09-23-2004 05:21 PM
David Nilsson Go to last post
3 107
Hello there I am trying to run xp_sendmail with an attachment. I have two attachments file1.txt and file2.txt, but I'd like implement in the...
09-23-2004 03:45 PM
Peter A. Schott Go to last post
1 98
Hi, I need to migrate a database from one server to another using DTS. The internal document that I'm following states "issues have been encountered...
09-23-2004 01:30 PM
Allan Mitchell Go to last post
1 75
Hi, In my DTS, I am using ActiveX Script to call SP. The reason I am using ActiveX to call SP is I have to porcess many XML and load into SQL...
09-23-2004 01:22 PM
Allan Mitchell Go to last post
1 74
New to DTS and not a DBA, but would like to know if source contains more fields than a target is it possible to add those fields to the target in DTS...
09-23-2004 12:51 PM
Allan Mitchell Go to last post
1 65
If I were to create a codebase / library of "functions", such as error logging "protocols" / "frameworks" or data handling routines in a single...
Wikus Schalkwyk
09-23-2004 12:44 PM
Allan Mitchell Go to last post
1 67
In article <9A0B2B3A-3F77-4401-91CD-5C14B4E0BFE3 (AT) microsoft (DOT) com>, Matrix wrote: Have you tried to oconvert this? VBScript does not...
Allan Mitchell
09-23-2004 11:43 AM
Matrix Go to last post
2 93
I've reviewed a couple of the posts @ sqldts.com and was wondering if it's possible to skip multiple tasks and jump directly to the end. I have...
Peter A. Schott
09-23-2004 11:36 AM
Peter A. Schott Go to last post
5 117
Hello We're developing some new code, trying to run a dts package from an asp web page. The package runs fine locally. However, when trying to...
09-23-2004 09:40 AM
Richard Go to last post
2 137
Here's what I'm trying to do. I want one set of DTS packages to be able to run concurrently with different data sources/targets without having to...
Gary C.
09-23-2004 09:13 AM
freterink Go to last post
1 99
When I did the upsize wizard, for the relationships, I thought it was set to DRI. However, it was set to Triggers. I have since moved my access XP...
09-23-2004 09:01 AM
Jacco Schalkwijk Go to last post
1 104
In article <A06F81AD-3496-4C1A-AA11-650D5E07BB1E (AT) microsoft (DOT) com>, JaneDoe wrote: Short answer is no. DTS packages are stored as binary...
Allan Mitchell
09-23-2004 08:47 AM
JaneDoe Go to last post
1 107
Just wondering....I have been specifying some simple transformations using ActiveX scripts in the import/export wizard in the transformations dialog...
09-22-2004 05:32 PM
alien2_51 Go to last post
1 67
Hi there, I'm using MS SQL Server 2000 SP3, WIN XP SP2, When I try to open a DTS package from EM in SQL Server I'm getting an error message: Invalid...
Oded Dror
09-22-2004 04:45 PM
Allan Mitchell Go to last post
1 89
I don't have an answer for you, but you're not alone. I ended up having to use a different machine because one SQL Server could hit our AS/400 and...
Peter A. Schott
09-22-2004 04:42 PM
Peter A. Schott Go to last post
2 84
I have mmc.exe application error "the instruction at "0x42d93767" references mempry at "0x00000000". etc in debugger Unhandled exception in mmc.exe...
09-22-2004 04:11 PM
Allan Mitchell Go to last post
5 187
Hello, Does anybody have any code samples/snippets (in VB) to create connections for the Source (an Acess database) and Destination (SQL 2000)...
09-22-2004 08:45 AM
DBI Go to last post
3 95
i need to develop a DTS package that uses Oracle8i datanase tables as source and SQL Server 2k tables as target. The mapping is one-one, meaning...
Guy Dillen
09-22-2004 08:25 AM
Miguel Salles Go to last post
4 96
Hi I'm not sure if DTS is the correct way to do this or stored procedure. Here is the code to produce and populate my test table CREATE TABLE ( ...
09-22-2004 08:15 AM
Miguel Salles Go to last post
2 85
I need to export .xsl file to sql server 2000 with out using DTS utility. Only through dts package or asp coding Any help would be greatly...
Dilip Singh Dodiya
09-22-2004 08:09 AM
Miguel Salles Go to last post
2 96
Are you using the iSeries Client Access client to access the AS/400 tables? Make sure your client software is up to snuff with what's running on the...
David Danh.
09-22-2004 07:51 AM
Miguel Salles Go to last post
2 75
Hi, When I try to create a new DTS package on a SQL 2000 Server, the VBScript Language is not available in the ActiveX Script tasks. I only get...
Christian S
09-22-2004 04:03 AM
Christian S Go to last post
2 81
Is there an ODBC or OLEDB driver for System 36? I want to import some data from an IBM System 36 data source into SQL Server. Thanks. *** Sent via...
Danny Crowell
09-21-2004 11:56 PM
David Danh Go to last post
1 81
I did that already. I also tried statement, or I have successful. But then it is only the first statement that is executed. It is not the pack that...
Jean Paul Gevaert
09-21-2004 02:51 PM
Miguel Salles Go to last post
1 68
I am developing my first package and need load a .xls file into a table in an Informix database. Everything looks straightforward except one of the...
09-21-2004 02:49 PM
Migue Salles Go to last post
2 77
We are running Lotus Notes as our mail system. I want SQL Server to send emails to Notes users can somebody please explain how to setup a mail...
Karen Middleton
09-21-2004 12:28 PM
Peter A. Schott Go to last post
2 145
Hi All, I'm trying to write an Active X task that waits for 2 parallel data pump tasks or excute SQL task to finish before it goes to the next step....
Dave Wong
09-21-2004 12:13 PM
Dave Wong Go to last post
2 64
I'm trying to get a bulk insert job to run from within a DTS task. When I run the DTS task "manually" by clicking Package/Execute from within the...
09-21-2004 07:56 AM
Teretsky Go to last post
3 213
Post New Thread

Display Options
Showing threads 5901 to 5950 of 9524
Sorted By Sort Order
From The
Forum Tools Search this Forum
Search this Forum :

Advanced Search

New posts New posts More than 15 replies or 150 views Hot thread with new posts
No new posts No new posts More than 15 replies or 150 views Hot thread with no new posts
Closed Thread 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

Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2015, Jelsoft Enterprises Ltd.