Are there any samples for DTS of SQL Server 2005 data to FoxPro mdf files ?
Thanks.

In brief:
We have an older, DOS-based billing system with the tables
stored as .dbf files.  We are currently building it's
replacement with a VB6 front on a SQL database.  The table

I'm working with SSIS 2005 and encountered with a problem with specifying
the log file path. I need to dynamically set the log file name of a child
package in the parent package. I use variables to achieve this. The problem
is, in the child package, before it has retrieved the ...

Hi, I'm definitely a newbie to SQL 2005. I'm importing data from MS Access
2003 and several tables have a status of Error.
The error messages in SQL 2000 DTS were helpful as they included table name,
column name and description of data problem that caused the error. This

I'm calling a VB.net exe using an Execute Process Task and it appears
to be timing out on me.  It runs for 3 or 4 minutes and then just
stops and returns an error 128.  I think it is timing out because 1)
if I run the exe directly it finishes completely without an error, 2)

Where I currently work we are using MS-SQL Enterprise Manager 8.0.  We use
DTS packages to copy daily production files from one area to another and then
load the data into a database.  I have set up DTS packages up to
automatically copy a set of files being produced every day ...

I'm developing my first SSIS project where I need to design a package
which would execute around 10 stored procs. All the 10 procs will have
to fetch data from a single Source table within a Source DB and insert
into each of the coressponding 10 tables in a Destination DB on the

I've got a bit of a problem doing some changes to existing packages on
our db.
When I do a small change; say, changing the path of the error log for
a transformation task and click ok. I need to wait for about an hour

Another classic example of something silly I must be doing :(
I have a "Foreach Loop Container" which uses a "Foreach ADO Enumerator".
The object source is a recordset variable.
Inside the "Foreach Loop Container", a lot of things are happening - some

I have a DTS package that is just a list of 'update statistics <tablename>;'
statements. The package has a log file that lets me know that the steps where
successful and low long the total step[s] took to run. I want to put print or
select statements in the the TSQL script so I ...

At least I think I'm after variables. But I'm not sure. I have a book and a
CD training course, and I've searched around here but have not been able to
find anything that answers my questions. I'm totally stumped - probably
because I know what the problem is, but not entirely ...

I am facing a very strange issue with the Send Mail Task:
I am fetching the recipient from a Recordset and storing it in a variable
(MailList).
Now, I modify the Send Mail Task to include an Expression which updates the

I have a DTS package vba task which loads a list of files into table.
It is possible that a file is already in the table from a previous cycle,
and as I only want a single entry for each filename, so I have put a primary
key on the 'filename' field, thinking that it would prevent ...

I'm unable to copy my Stored Procedures from one database to another.
I'm using mixed mode authentication.  I have set
CopyAllStoredProcedures to True, DropObjectsFirst to True and
CopySchema to True.

I'm using SS 2005.
I've got an SSIS package.  I'm trying to write some data to an Excel
Destination.  It keeps appending to what is there, instead of
overwriting.  So, I'm trying to give it a fresh file each time to