I have 4 different flat file struture in on
folder(_001.dat,_002.dat,_003.dat,_004.dat)each going to a seperate
table.  Right now the logic below grabs all files.  I want to be able to
filter on the file extension and send that to its own particular table.

In my DTS package i have "Truncate Table task" followed by "Package Success"
and "Package Failure" tasks.  
"Truncate Table task"  is connected to "Package Success" using  "On Success"
workflow.

I have serveral dts packages saved on the server.
they contain a very large amount of tables(hundreds)
i have made a ini file to determine the source database and the
destination(db and server) that works fine.

I'd like to thank everyone who has helped me in that past.  You guys have
been great.
I am outputting various fields from a table to a tab delimited text file.
(Thats the vendor requirement).  One of those fields is a varchar field that

what is the sql  command to be able to see the packages in the database?
Thanks

I'm transforming a 9 character field in a flat file that represents a dollar
amount. The decimal is implied inbetween the 7 and 8 characters. Also, if the
record payment status is "X", then the last digit is an alpha character that
represents that 1) the amount is negative, and ...

I've used your tips from http://www.sqldts.com/default.aspx?218,1
(multiple paths in workflow) and the above article on performing a
multi-step in my DTS package.  What I can't figure out is this:
1.  If I have two multiple paths in workflows in my DTS package and one

I face this problem hope some body can help me to solve
this, TQ
I create one local DTS and can run properly, after that,
i try to create a trigger to call the DTS, the trigger

Hello Friends,
I have a data file containing Purchase Orders coming in
from a proprietary ERP system.  The file contents can be
divided into 3 parts: Header, Lines and Notes.  These 3

I need to export from couple table data to a csv file.
But I don't know how to do the following.
The table will, OrderID,  no of item, item no, qualtity description.
                    5020023, 2             , 1      , 1          , Cable

When executed manually all is well, connection
is made to both sides and data flows nicely.
When I schedule this package to a job it runs but step is stucked.
There are no logs or any other information.

I want to copy all the stored procedures from one sql server to another sql
server by using Import, then I get "Fail to copy objects from Microsfot SQL
Server to Microsfot SQL Server" error. I can't find any detail of the error.
The source database info is

We have been encountering this message when running three DTS packages
between two database servers:
Step Error Source: Microsoft Data Transformation Services (DTS) Package
Step Error Description:ActiveX Scripting encountered a Run Time Error during

What does letter 'N' means in this syntax?
if exists (select * from dbo.sysobjects where id =
object_id(N'[dbo].[ImportFileData]') and OBJECTPROPERTY(id, N'IsUserTable') =
1)

I am trying to modify a DTS package connection to use
a .udl file.  When promoting the package I have to ensure
that there is a .udl file on every environment using the
same name in the same location.  That is not a problem,