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 09: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 06: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 04: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 03: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 03: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 01: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 11:32 AM
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 11:03 AM
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 09: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 08: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 07: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 02: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 01:03 AM
Allan Mitchell

I am migrating data from mainframe to SQL Server 2000. The mainframe has a utility that dumps all the datatables in the mainframe database as .csv...

Rajesh Krishna

07-02-2003 06:44 PM
Ray Higdon

Is it possible to have a lookup with multiple parameters? If so, how do you pass them via an ActiveX script? Example: Select * from employee where...

ScubaFrog

07-02-2003 06:02 PM
ScubaFrog

I am getting an error while executing a Job ..Has anyone got an idea about the same..The error goes like this... Executed as user:...

Harcharan Jassal

07-02-2003 04:04 PM
ionel

Hello, I have DTS packages being run within a VB client through the DTS object library, and would like to run the packages in an asynch fashion if...

Greg Hayes

07-02-2003 03:42 PM
Darren Green

Ok, I posted a follow up that I got this working. And now I can dynamically change the file name. Very fun. Now the icing on the cake would...

Neal Myerson

07-02-2003 03:35 PM
Darren Green

DOH!! Figured it out. Hmmm... how about Save As... There are somethings that really leave one feeling stupid. -Joseph

Joseph

07-02-2003 01:35 PM
Allan Mitchell

I'm trying to copy the data from 1 file to another file. When I create the task transform copy and specify the text file name in the source tab and...

please help

07-02-2003 12:40 PM
Darren Green

Hello, I try to send data from sqlserver 2000 to a remote DB2 as400. The AS400 is connected with a dedicated line. Now, if i run the DTS package...

Marco

07-02-2003 11:39 AM
Steve H

Hi Folks : I have an excute SQL Task in DTS Package. I am excuting a sproc which has three output parameters . I would like to assign the values to...

Dhanraj Mahendra

07-02-2003 11:29 AM
Darren Green

thanks allan. i am not using visual basic. we have enough problems using dts from within the designer. anyhoots, dts dies a stray dog's death in...

Karthik Nagaraj

07-02-2003 09:03 AM
Karthik Nagaraj

Hi all, I have a file that looks like: 123456.pms03071 The first part, 123456, is unpredictable. The second part is pmsYYMMDD. What I want to do is...

Kent Johnson

07-02-2003 04:21 AM
Darren Green

I have an xls file that I want to import into a table within sql2000. I have built a DTS that does a simple column copy with a lookup to import the...

John Pether (john@

07-02-2003 04:21 AM
John Pether (john@

I have an annoying issue with a dBase 5 import. The data is transformed in a standard manner - DTSDestination('x')=DTSSource('x') However, null...

liferily

07-02-2003 03:48 AM
liferily

Hi ... I got a job using Web Publishing to generate report based on the data returned from store procedure. Lately, I got some funny problem...

Panther

07-01-2003 11:39 PM
Panther

What does the following error mean: Server: Msg 1032, Level 15, State 1, Cannot use the column prefix 'a'. This must match the object in the UPDATE...

Mel

07-01-2003 05:11 PM
Mel

I need to copy a rather complex DTS package from a Dev server to the production server. The package was saved in SQL Server. Is there a way to do...

Joseph

07-01-2003 04:51 PM
Edgardo Valdez

Hello, I would like to allow the package designer to select a configured connection in my CustomTaskUI property page. However, I have been unable...

Ryan Hoegg

07-01-2003 04:25 PM
Ryan Hoegg

I don't know what planet people come from when they say this stuff is easy. Of course calling DTS from a stored procedure may be easy relative to...

Jeff

07-01-2003 03:05 PM
Jeff

I am trying to import FoxPro tables from a NT4 server. The DTS package fails during it's scheduled operation. It says it can't find the FoxPro...

Ron Huffman

07-01-2003 02:50 PM
Andrew J. Kelly

I am running some DTS tasks against an Oracle database and have some questions. I can establish my connection alight via OLE DB. When I query the...

Andy

07-01-2003 01:43 PM
Edgardo Valdez

I use login authentication for all my DTS and job. But recently my jobs have failed because the domain that authenticates these logins are having...

Helena Silva

07-01-2003 01:25 PM
Darren Green

In article <#sL6mKxPDHA.1624 (AT) tk2msftngp13 (DOT) phx.gbl>, David Oxe <david (AT) oxe (DOT) se> writes David, Why does you "create table" step...

David Oxe

07-01-2003 01:10 PM
Darren Green

Hello, our server crashed, we move to another server with the database.... how do I recreate the DTS Packages and Jobs. Where is the information...

Jason

07-01-2003 12:11 PM
Andrew J. Kelly

Transforming text from Excel to SQL database.

jim

07-01-2003 08:38 AM
jim

Allan, the encrypt step is done from SQL?. If it is the case how do you do it?. I haven't found anything in SQl's documentation. Thanks,...

Juan

07-01-2003 07:58 AM
Juan

Is there a limit to the number of characters that can be passed to the "Parameters" line or "Win32 process" line of an Execute Process Task? I am...

Robert R

07-01-2003 03:59 AM
Krisztian Pinter

Hi, I want to know if it is possible to get DTS to do updates if an insert fails. I am using a Transform Data task. (SQL2000) I am importing sales...

Yossi

07-01-2003 02:54 AM
Yossi

My error in schedule DTS is: DTSRun: Loading... DTSRun: Executing... D TSRun OnStart: Transfer SQL Server Objects DTSRun OnError: Transfer SQL...

Livio

07-01-2003 01:34 AM
Allan Mitchell

Use the ExecuteProcess task and FTP The SQL Server 2000 FTP task is down only -- Allan Mitchell (Microsoft SQL Server...

Allan Mitchell

07-01-2003 01:29 AM
Allan Mitchell

DTS Packages are stored (In the main) in MSDB. Guest is (In the main) a user in MSDB and therefore is a member of Public Public has execute...

Allan Mitchell

07-01-2003 01:28 AM
Allan Mitchell

Originally posted by Don A solution I can recommend is to put the delimiters yourself, by looking at the data layout of the text file. The way to do...

Ricky_Singh

06-30-2003 08:01 PM
Ricky_Singh

Hi, I'm trying to dynamically import data into MS SQL Server 2000 from a text file using a DTS Script written in VB. The first row of the text file...

Anthony

06-30-2003 06:28 PM
Edgardo Valdez

Hi I have been given 400 files to import into sql server 2000 they are all the same layout I have imported one using DTS GUI no problem how can I...

shau

06-30-2003 05:46 PM
Ryan Hoegg

In double blind placebo controlled studies, 4 out of every 5 DBA's preferred DTS over Dolby. I think that 5th one also liked MySQL. Ray Higdon MCSE,...

brad

06-30-2003 05:32 PM
Ray Higdon

Can I programatically retrieve the path of the exception file used during execution of a DTS package?

Matt Crego

06-30-2003 04:28 PM
Matt Crego

Hi, I tryed to run DTS with Report Preparation Task. And it stucked with running Report Preparation Task for more than an hour, so i had to cancel...

Svetlana

06-30-2003 02:56 PM
Narayana Vyas Kondreddi

Go to SQLDTS.com and search for the word "Loop" to find some examples. -- HTH, Vyas, MVP (SQL Server) http://vyaskn.tripod.com/ What hardware is...

Narayana Vyas Kondreddi

06-30-2003 02:53 PM
Narayana Vyas Kondreddi