I am trying to import log file from a monthly generated log using DTS. The problem is that the log file name changes every month and I want the text file (source) to change to the same file name.
I have created a DTS like this:
A. Set the current Text file path with a "Dynamic ...

   I am working on an application that interfaces with an AS400. The AS400
programmers I am working with at the client, are not very flexible. They are
providing me with data for the initial database load for the application to
go live. After that my app will take care of all data ...

I NEED TO DEVELOP A DTS TO READ SUBJECT FROM ALL MESSAGES FROM A SPECIFIC EXCHANGE INBOX, AND IF POSSIBLE MARK AS READED.
HOW CAN I DO THAT?
THANKS

I've tried about everything. My problem is that I have this .asp page
that executes a DTS Package, this package gets some data from a table,
saves it into a text file. No problem so far.
Now I would like to move the file from my server to another server =

Hi all and happy new year.
I've got a problem to join transactions in a package.
In a package, I've got two OLEDB connections to the same database (sql2k) to
tranfer Data from one table to another with a DataPump.

I would like to know if Bulk Insert Task is supported in SQL Server 2005.
Also more specifically if there will be any changes to loading using the
format file.
thanx

I want to execute a package from a server that I dont have install sql using
coldfusion page.
What files can I include in this server so I can execute this package?
<CFEXECUTE name="c:\program files\microsoft sql

I have a scenario where inspector's synchronize their PDA's at the end of
the day (we use SQL Server Merge Replication).  When an inspector is done,
I'd like to kick off a cleanup process (that code would be in a dts
package).

Currently I am loading a table by reading a flat file.
Since I am loading more than 5 million records it is taking some time to
load the data. I am using DTS package to read the data.
Is there any alternative(other than DTs package) to read the data from flat

I am trying to use DTS in my VB6 app, but cannot figure out what files are
required for my set up program.  DTS in my VB6 works on my machine with SQL
Server, but I want to run it on another comptuer.  I am using Install shield
to create a setup program, but when I run the ...

I've been trying to get bulk insert to work and have this statement
bulk insert dbo.myTable from 'c:\test.csv'
with (datafiletype='char', FIELDTERMINATOR = ',',ROWTERMINATOR = '\n')
I'm trying to get this to work in the SQL query analyzer. But i see that it

Is it possable to update a Global variable in another DTS package that is to
run later from a stored procedure that is running in a package now
Thank you