Hi, I would like to see only error messages of packages that fail. I have setup packages that import data from text files that are FTP from the...

Donna

07-07-2003 05:37 PM
Allan Mitchell

Trying to figure out if there is a way to use the cmdexec command without having adminsitrator rights...I am not in a domain so I can't use the proxy...

07-07-2003 05:29 PM

I have recently installed Service Pack 4 for Windows 2000. My machine is running SQL Server 2000 with SQL Service Pack 3 and the latest available...

David

07-07-2003 04:51 PM
David

Here is the situation I'am having. I have one DTS running on a production server SQL Services running on as "LocalSystem" account. Package works fine...

Gerardo Delgado

07-07-2003 04:13 PM
Gerardo Delgado

Can anyone tell me why "Meta Data Services" does not appear in the location list when I try to save a DTS package? Thank you

Jim Whipkey

07-07-2003 04:03 PM
Jim Whipkey

Hello: I have created a SQL2K DTS package that drops 2 tables in a reporting database and replaces them with new data. I use a SQL task to drop the...

Brennan

07-07-2003 02:07 PM
Brennan

I'm stumped. I know this is probably something very simple but I just don't see it. (Running SQL 7 sp4 on W2K Server) For simplicity, I created a...

george

07-07-2003 12:56 PM
george

Yes when the package is run as a job, the majority of the packages run using the script below, 3 of the packages do not run, and no errors occurs. I...

Mark Phillips

07-07-2003 12:54 PM
Allan Mitchell

Hi All, I hope someone can help me, I created a DTS job using the wizard which reads a tab delimitied text file and inserts it into a table, and...

bernif

07-07-2003 12:01 PM
Allan Mitchell

Is there a way of telling whether a DTS import actually read to the end of the data import file, rather than (say) reading n-number of complete...

GriffithsJ

07-07-2003 11:28 AM
GriffithsJ

Hi, The sa being quite busy these days, (with the sun and all ;-)) I talked to him this morning. Totally correct with the accounts response....

El No

07-07-2003 11:06 AM
El No

One more thing: the executed package is very simple: there is only 1 Active X Task: raising the error - for testing purposes. Does matter settings...

Tomek R.

07-07-2003 10:47 AM
Tomek R.

mark, you don't need to export from access. You can import Access databases from SQL Enterprise manager using the Import/Export Assistant. From there...

Heiko Oberleitner

07-07-2003 10:05 AM
Mark

Dear all I've a DTS package with three independent lines of work-flow in it. I've set the package property "Fail on first error" to be FALSE. As...

GriffithsJ

07-07-2003 10:04 AM
GriffithsJ

No, thx. But Installing MSXML 4.0 helped. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag news:eoTjfzGRDHA.3192 (AT)...

Heiko Oberleitner

07-07-2003 09:53 AM
Heiko Oberleitner

Hi all I have a package reading data from an ini file in the first step. I need to move the package on production server (on e:, i developed on my...

Roberto Galbiati

07-07-2003 07:23 AM
Allan Mitchell

Hi! I am new to DTS scripting and I was wondering if there's any way in DTS to scan an existing table and change a field's value. I am generating a...

Greg_Del_Pilar

07-07-2003 06:10 AM
Jacco Schalkwijk

I was wondering if anyone could point to a website that would help translate VB into VBScript.. Reason is that I had a developer create a VB...

ScubaFrog

07-07-2003 03:15 AM
Allan Mitchell

Hi ... I got a job using Web Publishing(sp_makewebtask) to generate report based on the data returned. Lately, I got some funny problem which never...

Panther

07-07-2003 12:19 AM
Panther

I have a DTS package that imports a fixed-field text file with Linefeed (LF) characters delimiting rows, that works fine when run from the designer,...

Charles Richardson

07-06-2003 04:24 PM
Charles Richardson

Thanks, I'm using 2000 and method 2 worked great. "Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Chris White

07-06-2003 03:23 PM
Chris White

Gert, I am currently using the DTSPackage library. I am instantiating it inside of Microsoft Navision using C/SIDE code. I seem to have some...

Devin McMahon

07-06-2003 11:49 AM
Gert E.R. Drapers

Euan Garden,Group Program Manager for SQL Tools and the Manager for DTS, mentioned in SQL Server Monthly Chat back in May 24, 2000 on SQL Server...

Tony Maudar

07-05-2003 05:05 PM
Tony Maudar

Hi there, I´m trying to export a "ntext" field in which I have stored notes (a lot of text). I'm using the Query Analizer, but the select command...

Charles

07-05-2003 03:43 PM
John Bell

I have a problem Package is stored in msdb database.But I was surprised to see many package in the database table sysdtspackage. How is this...

Aneesh

07-05-2003 04:42 AM
Darren Green

My site is occasionaly crashing. I feel this is due to some package. Am i right if so how Can I deburg it. Thanking in advance

aneesh

07-05-2003 02:15 AM
Allan Mitchell

Hello everybody I want a dynamic properties task to set the treekey property of an olap processing task to one of its partitions. From some reason...

Rea Peleg

07-04-2003 05:47 PM
Rea Peleg

I am working on a project where I need to connect some Windows 2000 (SP3) servers to an IBM AS/400 database. I'm using IBM's Client Access OLE DB...

Jeff Roloff

07-04-2003 11:57 AM
Bill Cheng [MSFT]

Hi, I am trying to use a DTS package for horizontal partitioning in a transactional replication. I want to use a lookup from another connection...

Askin Karakas

07-04-2003 11:20 AM
Askin Karakas

Hello, I get the following Error after executing a DTS-Package on a SQL2k SP3 or SP3a. The scenario: Copy objects between two SQL Server. Both SQL...

Manuel Rodriguez

07-04-2003 10:41 AM
Manuel Rodriguez

I have a dts where I am transfering data from dbf to sql server database. I receive de following message but I did not find answer in microsoft...

Fabiana Sasia

07-04-2003 10:38 AM
Darren Green

Hello, How can I change the creator and computer of a DTS-package with something simular to sp_reassign_dtspackageowner. Regards, Hans

Hans Neckebroeck

07-04-2003 08:42 AM
Allan Mitchell

Hi! I am a newbie to DTS. Below is a sample code which copies the data from a source text file to a destination text file. Assuming that there are...

Elgar Esteban

07-04-2003 07:16 AM
Paul Ibison

I am trying to fetch data from an Oracle database to SQL Server 2000 database. The fetching does not take very long time (around 2 mins) if it's...

Erica Santosaputri

07-04-2003 01:42 AM
Allan Mitchell

Hi, I'm running SQL2k sp3 on a dual Xeon w/four drives/arrays (SCSI)(OS on C:, Logs on E:, tempdb on F:, Data on G:(500GB)). I have a large...

Fred Jones

07-04-2003 01:42 AM
Fred Jones

I need to take a hierarchical text file and import into a set of relational tables. The first three characters of each line identify the format of...

michael

07-04-2003 01:40 AM
Allan Mitchell

Hello, I have tried to export a table that contains fields of datatype decimal, however, when I export the data to MS Access, the values to the...

Sammie Barnes

07-03-2003 11:19 PM
Jono Indrawijaya

I've set up a bunch of DTS packages to import from delimited text file where the first row has column names that match exactly the field names in an...

mirsk

07-03-2003 10:32 PM
Jono Indrawijaya

I had this same issue, and what fixed it for me was removing the "USE <database_name>" clause at the top of the query. I.E., my query looked like...

Spencer Maiers

07-03-2003 07:00 PM
Spencer Maiers

I am attempting to export various tables to Excel 2000 - however am finding that some of the table records are losing their key field data - and are...

Phillip Barwell

07-03-2003 05:29 PM
El No

I doubt you will find a way to do it. DTS must take every row you give it and issue an UPDATE Statement against it. This can only be achieved in a...

Allan Mitchell

07-03-2003 04:33 PM
Allan Mitchell

What you could do is clean the files so 1. Strip out the data to a seperate file 2. Place data file in a directory You now have two files for...

Allan Mitchell

07-03-2003 04:30 PM
Allan Mitchell

Hi All, We need to execute a task 2 times before we proceed with the next task. Say for example A - B - C - D are tasks in sequence. We need to...

Sumathi

07-03-2003 02:55 PM
Sumathi

Hi, I am having problem creating a connection to Oracle database using DTS designer. We have Oracle 9i on a Linus box. I installed oracle 8i client...

Egbon

07-03-2003 12:32 PM
Egbon

Hello, Salim! Quite Simply ....Yes -- Allan Mitchell (Microsoft SQL Server MVP) MCSE,MCDBA www.SQLDTS.com I support PASS - the definitive, global...

Allan Mitchell

07-03-2003 12:03 PM
Allan Mitchell

I am trying to bulk insert a fixed-length file. I have columns that have no data in them. The data is being imported into SQL Server as spaces...

Brendan Lane

07-03-2003 10:33 AM
Brendan Lane

Hello, Salim! If some tables have not got a PK then how do you hope to identify a record ? If you cannot identify a record then you can't compare...

Allan Mitchell

07-03-2003 09:25 AM
Allan Mitchell

Hello, Sai! I have a package at home that does this with a simple select statement so mail me provately to remind me and I shall send it...

gsv

07-03-2003 08:19 AM
Sai

Thanks for the info. I have done all the dll's and files on the IIS box w/out the sql server, but it still fails. The sql server has IIS turned off...

wahoo

07-03-2003 03:23 AM
Allan Mitchell

SQL gurus, please help... I am trying to import a .csv which has date and time in a column in the format "01Jan00:00:01". When I specify the field...

rk

07-03-2003 02:03 AM
Allan Mitchell