Is there a way to force a DTS .txt file to always be a set length?  I have
fixed length fields and the customer needs the record to be 80 characters.  
Do I need to create a 'dummy' variable to be a filler a blank spaces?
Thanks

I have a windows service on several remote machines that gather data and
load it to SQL 2000.  The service on the remote machine runs at a desirable
frequency and gathers the data.
I'm using DTS on a central server to bring the data back.  The DTS package

Temporary table (#table) data remains through a series of DTS sql
steps. I am even able to dump the data to excel. But just after that
temporary table is lost. Why does it happen?
Does the sql connection gets lost once i hit a task having excel

I am using DTS to import tables into my new database from another
database, both of which reside on the same server. All the tables,
fields and data copy over fine; however when I go into design view of
the copied tables, the default values for all the fields are lost. It

I am successfully executing a DTS package from a VB app on the
development workstation, but having issues when trying to execute from
another client workstation...
The DTS connects to an .xls table, drops an existing SQLServer2000

I try to import the data below from a text file using the SQL Server 2005
import wizard with a "Flat File Source" and receive the error "SQL Server
Import and Export Wizard / The preview sample contains embedded text
qualifiers ("). The flat file parser does not support embedding ...

In the DTS package, how do I change the file location dynamcially? I
need file location to be changed depending on what server the DTS
package running on. I am using @@servername for this purpose.
This DTS package is very simple. It is importing a TEXT file into a SQL

We use a few custom tasks in our system in several DTS packages.
How can I query tables in MSDB to find all packages using a DTS task.
Also, how can I find a particular task property in various DTS packages
from the MSDB tables.

What has replaced DTS in SQL 2005 and how do I create a new DTS package (or
the equivalent) ?

i am a little bit confused , i write an sp which creates DTS.Package object
and uses LoadFromSQLServer method to load DTS package.
i exec this sp within VB code in a ASP page. Web server and Sql server are
on the different machines. where does the package run ? on the web server ...

Table A is created in an Oracle d-base randomly every day...sometimes 5 am
sometimes 11 am...very unpredictable.  Every day when the query is run that
builds the table, it overwrites the previous day.  Once I successfully import
the table I can fire my scripts.  Right now I've ...

I am trying to code a DTS export package to select records from a table where
the significant date field is a CHAR length of 8 variable.  The values are
like '20051027'. I want to code a SQL statement to select all records for the
current (system) date.

I'm assuming this is a simple question, I can't find a solution though.
Hopefully this makes sense
1) I have an excel file with the following columns:
First Name

I have to take the output stream from a stored procedure and turn it into a
text file. I do not know how to do this without writing it into a table and
then using the table as a datasource, which seems lame.  Is there an easy way
to do this?

I want to use DTS to build a text file and a dollar field must be right
justified, left zero filled and no decimal.  Is there a tranformation that
can be used on a field that is defined as 'decimal 9(15,2)?  Do I have to use
SQL or tweak the VB code that can be generated?  If ...