Can anyone tell what I'm missing to be able save an excel workbook to
text format using dts.
Excel_WorkBook.SaveAs "E:\EXcelData\rabbit.txt"
Which save's it fine , but I need to be able to set the format for this

I'm trying to save a excel file to tab delimited format using a dts script.
However I can open the sheet I can save the sheet as a different name,
but I don't seem to be able to save it as a tab delimited file
Can any one help ?

Has anyone had the issue where you have jobs executing or retrying and
the server maintenance people reboot the server?  After the reboot, I
have been manually restarting any jobs that were executing or retrying.
Is there a way to restart the jobs automatically/progammatically?  Is

I have mixed data in one Excel column (integer and string). If the integers
on the top I can only import integers and all string values will be NULL. If
the string values on the top I can only import strings but the integers will
be NULL. Is there any way to import mixed data?

I'm calling an Execute sql task from my script programmatically and I want
it to return its result which is a count into a global variable?? How should
I specify it?
Thanks

I have a SQL Server 2k DTS Package which is missing/ignoring rows when they
are transferred between tables. The source is a Query covering 15 tables and
the destination is a single table. When I run the Query in Query Analyzer I
get 87000 rows return yet when I run it as part of ...

 I have a text file over 70000 lines, some lines are long some are short.  
I tried to import this text file into SQL, but all it did was to take the
shortest line as the width and truncated the long times.  Though I have in
the "transform" to change the field to varchar and ...

I am importing a flat file using dts. I notice that if there is an
error in the file, the transactions are rolled back. I need to import
each row as a transaction in itself. How do I do that ?
For example if the There are 2000 rows and 1 row is bad then 1999 rows

Folks, (sorry bit of a long story)
I Tested a DTS package last week.  Nothing too complicated one connection to
SQL DB and one to Oracle DB.  It runs thirteen select and update statements
against the Oracle DB.

Hi, I'm Jennifer Kenney, I'm mostly SQL/TSQL, but I'm using DTS for obvious
DTS things, and I've got an issue with DTS respecting the Row Delimiters in
a text file (source) connection.
The fixed-width text file has a CRLF row delimiter, visible when I read it

I have a Windows 2003 server running SQL Server 2000 with a linked server on
Windows 2000 server running SQL Server 2000.  Both machines are on the same
domain and Distributed Transaction Coordinator is running.  I have applied
the instructions in KB article 817064 (

I have DTS which uses global variables and dynamic mapping to map to the
variables as per the parameters that i send from the Stored procedure that
used to call / execute the DTS.
My DTS has to export data from a SQL Server (Join Based Query) to a TARGET

I have saved a DTS file as a Visual Basic File.  I have two questions.
Can I create a button in Excel that will execute the DTS and how do I do it?

Thanks

I use the DTSRUN utility with /L option to provide the log filename with
path for logging.
I think in Package property "Error File" option is same as the above but
there the NAME will be given in design time.

I am using this task to report errors to admin.In our production enviroment
,there is no Exchange server or everything else.What is this task using for
sending emails? Do I have to configure things in production server?
Thanks