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 07: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 07: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 05: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 04: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 04: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 02: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 01: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 12:39 PM
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 12:29 PM
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 10: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 05: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 05: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 04: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-02-2003 12:39 AM
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 06: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 05: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 05: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 04: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 03: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 02: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 02: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 02: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 01:11 PM
Andrew J. Kelly

Transforming text from Excel to SQL database.

jim

07-01-2003 09: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 08: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 04: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 03: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 02: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 02: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 02: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 09: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 07: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 06: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 06: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 05: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 03: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 03:53 PM
Narayana Vyas Kondreddi

Thanks Allan, That definitely helped. Giving it the full path to DTSRun.exe did the job. -Deep *** Sent via Developersdex...

deepankar sogani

06-30-2003 01:59 PM
deepankar sogani

This has been reported as bug. Check...

SriSamp

06-30-2003 10:29 AM
SriSamp

I have the following error message while executing DTS: Step Error Description:Need to run the object to perform this operation (Microsoft Data...

Alexandr Zaspenko

06-30-2003 04:43 AM
Alexandr Zaspenko