I have a list of text data files (*.TXT) that I'm trying to import
into my DB.  The files have the year and month the in the file name
(for example:  ABC0301.TXT would be for the month of Jan-03).  One of
the first steps in my package is an ActiveX Script Task that I want to

I am trying to automate upload task at midnight. For this I have create file
which generate TAB delimited file, then I create a FTP connection file and
thne execute this ftp script for upload the file, but file is still not
uploading to FTP server. If I Upload file manually, file ...

I am not sure if this is possible or not but I am trying to do the following.
I need to export data to a test file in the following format:
[Users]
firstname=john

I have need to produce a report (excel sheet actually) from SQL that
would run each Tuesday and each Friday of every week.
What needs to be on the Tuesday report is everything that came in from
the Friday midnight time, until the Monday midnight time.  The friday

I need to dump Access MDB files to SQL Server 2005. No extract and transfer,
just transfer the raw data. However, the mdb files can be reaching the
limitation of 2G.
Is there any benifit (especially performance) to use SSIS to load the MDB

I'm using DTS in SQL Server 2000. This is the first time I've used it
extensively.
I have a task which is trying to "manually" roll back a set of steps if any
errors have occurred in a previous step. In the Execution Progress dialog,

Howdy all. My goal here is to be able to be able to move a DTS Package from
one box to another and not have to specify the new box name in the DB
connections. I know I can do it in the Global Variables under Package
properties, but that's not all that great either.

I have database with many relationsips
At the start it is empty and when i'm trying to import to it data. some of
the tables are failed due to key violations
Is there a way to import the data in this cases?

I've run dts between two servers that connected by the internet, and one of
the tables failed.
I've transfered 78Mb, and the log file has increased in 100Mb.
Whayd did the log file has increased that mutch?

I need to move some data generated from a SQL Server 2000 scheduled job over
to Exchange 2003 calendar. After some research, it appears that a DTS package
could do the trick for me.
My questions is, does anyone know how to connect to Exchange from SQL DTS? I

If DTS is not supported in the new Workgroup version of SQL 2000, how does
one get data and SPROCs in and out of a server?  Is there some
replication-like process to transfer from one SQL site to another without all
of the transfomation capabilities of DTS?

I have a DTS package that performs data transformation from a flat file to a
database table.  I've added two columns to the table but, the two table do
not show up when I look at the transformation tasks in mu DTS package.  
Shouldn't the new columns show in the transformation ...

I have a flat file with 3 million records.One of the field is numeric. What I
am trying to do is transform the flat file data into sql table.The DTS
Package fails. The Reason it fails is that one of the Numeric Field has Blank
value in it.what do I need to do within a DTS Package ...

Is it possible to output the content of a table into .txt file using UTF-8
encoding and how?
Thanks in advance.

I have a web application  from where I need to execute  a DTS,
my platform is  SQL 2000 and .net 2003.      From  a Vb.net module I want to
execute the package, my  question is: does the package need to be STRUCTURED
STORAGE FILE or could it be SQL SERVER package (local to the ...