I have never done a DTS package. I need to be able to look for a tab
delimiler file at a specific time, say 2 am, parse threw it and replace
records in the database. Is this possible, if so, is there any examples how
to do this

I have a package that runs every day and prints out a series of reports. The
reports are generated into text files and printed by feeding the file name to
a Word application object and then using the PrintOut method to print the
file. I also select the printer. On occasion, say once ...

Is there a way to pass a users input through a DTS parameter that has a
integer data type without puting a constant in the value column. Ex A
string parameter accepts a ? for an input. However a @id
(Integer(small) will only take a number in the value rather than accept

SQL Server 2000 DTS Questions
1.        In a DTS package, I am using an ODBC connection as a destination
for a transformation task.
           The destination table name uses the format

Please forgive the very basic question.
I have two SQL Server 2000 databases.
The source database contains data I need to port, and the destination
database is a mere shell of tables ready to accept the data. Once

I have a table in Excel with about 4000 records which I need exported to an
Excel Spreadsheet. This has to be triggered via an ASP.NET app via the web.
I have been trying to use DTS but some wierd things happen.
1) All the numeric columns in the table are recorded as strings in ...

Hello, I have a need for a web application to request a stored
procedure to be run and then the results emailed to the user in Excel.
My web applicaiton is in ASP.C#.NET.  But I want to use parameters to
supply the

I have setup DSNs before to text files with some success. I am having
problems with a file I have to parse to pump into SQL Server via DTS.
It appears to be fixed length (what does the 'length' refer to
normally-the text plus the spaces to get to the first character in the

i can't find out where does the sql server save my DTS packages. i have seen
that there is something in the msdb DATABASE about DTS but i couldn't find my
DTS package over there.
any ideas?

Hey eb
My dts step log is growing to much.
I want to add a step to this dts which will
shrink it by deleting records from table msdb.sysdtssteplog

Is there any way to pause execution (Sleep) in java script
under DTS? WScript.Sleep() doesn't work. As I understand
sure workaround is to build my own activex with one method
Sleep(), but may be there is some simpler method.

my sql instance stopped working! I was able to save all the mdf and ldf
files, but have no idea where the dts are.  Please any help will do!!!

I have a query, which selects three columns from an inner join.  The last two
columns are SUM and the first one is GROUP BY.  Now, I would like to add
another column that will be the multiplication of the second and third
columns. I have tried many ways but I am not very sure if ...

How can I recover a DTS without recover a old msdb database over current msdb ?

Can you guide me how to set up alert for MSDTC service,
My goal is to get notification when MSDTC is failed.
thanks
kalyan