Re: Export to Text File Fails from Server Box

From: Allan Mitchell (allan_at_no-spam.sqldts.com)
Date: 10/09/04 

Date: Sat, 9 Oct 2004 11:32:56 +0100

DTS is a client side tool so.

The location of the text file has to be relevant to the place where you push
the button.

If you are on WKSTN1 and you pick up a package from SVR1 and press execute,
the package is executing on your box _NOT_ the server.

You should not have to change the package at all. You should also be using
UNC to specify the location of the text file. 

-- 
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com
"TomTait747" <TomTait747@discussions.microsoft.com> wrote in message 
news:3519FD4B-D8A6-4705-B582-47298096086D@microsoft.com...
>I should have specified in my question that in re-creating the text
> connection, I did point in to a file local to the SQL Server. This is not 
> the
> problem.
>
> "ilona" wrote:
>
>> It is ok to export from SQL Server box. Look in the file location for 
>> your
>> text file (Connection Properties/File Name) and make sure it points to 
>> the
>> correct directory that exists on the box that you run your DTS on.
>>
>> Regards,
>> Ilona Shulman
>> Senior Development Consultant, DBA
>> SSE Inc
>> http://www.sseinc.com
>>
>> "TomTait747" <TomTait747@discussions.microsoft.com> wrote in message
>> news:BEF31A7D-F24F-40DF-82CB-EC55BD65F50F@microsoft.com...
>> > I have a package that successfully exports to a text file from my 
>> > desktop
>> > (where I originally developed it).  I now want to run the package from 
>> > the
>> > box where the SQL Server happens to reside (in case that's relevant) 
>> > and
>> > cannot do it despite deleting the text object and rebuilding the
>> > "connection-to-text file output".  It is while rebuilding that 
>> > "transform
>> > data task", the black line between the db connection and 
>> > export-text-file
>> > connection, that the problem becomes evident.  When I click on the
>> > Destination tab, there is an execute button.  From my desktop, after I
>> click
>> > on the execute button, I can go to the transformation tab and all of 
>> > the
>> > field have transmation lines/arrows going from the source side to the
>> > destination side. After I click on the execution button on the SQL 
>> > Server
>> > box, I do not get the transformation lines/arrows.  This is the case
>> > regardless of deleting both connection objects and starting from 
>> > scratch.
>> Is
>> > there some limitation concerning exporting to a text file from the box
>> that
>> > holds the SQL Server?  What could be the limiting factor here?  Any 
>> > help
>> > would be greatly appreciated.
>>
>>
>>
Loading