I'm migrating a SQL Server 2000 instance to a new box running SQL
Server 2005. I've installed the SQL 2000 DTS components on the new box
which runs 2005 cause i need my existing DTS packages to keep running
on the new box.

Hey guys,
I am importing CSV files from a directory.  These files may either have
5 columns or 4 columns (missing the last one).
I wish to import the 4 column version into an errors table in the db,

I need some help from you guys. As part of my new job, I need to create a
DTS Package to syncronize the production and QA Databases.The steps to
follow are
Say for example the databases contains more than 100 tables and we need to

We're having to move SQL to a new server, which must be a new name.
Previously, I had been using an old name, and when the server was
replaced, we just gave the new one the old one's IP and name when we
brought it online.

I am new to DTS world.  I was able to save a dts package (in local packages)
and execute it manually without problem.  I am trying to schedule it to run
daily but nothing happened on scheduled time.  Could anyone please point me
out?  Where can I check the log?  Thanks.

Oracle 10 import DTS package with 11 tasks, 1 task per table.  Yesterday I
added more tasks after this package has been working for a month.  There are
2 tasks (Delete from existing table, transform Oracle to SQL Svr table), 2
connections (Oracle, SQL Svr 2k) and 1 workflow "on ...

I've many rows and I want to split them in many columns, with SSIS.
I've this scenario:
INPUT TABLE
id            date

I'm using an "Integration Services Project" / .dtsx package to load CSVs into
my SQL Server 2005.  Many files represent dates as "YYYYMMDD", and I want to
convert those to feed a SQL "smalldatetime" column.  How do I do that?

Running into a problem with SSIS and a google search doesn't yield much
help.
I have a package with multiple tasks and about 10 OnError event
handlers defined (one for each task).  I need to go in and change the

Does anyone have any suggestions for a decent DTS book for a beginner that
explains the product in pretty good detail that would enable me to utilize
and get up to speed pretty quick with a decent index so that I can use it as
a reference as well???

I get the following error when adding a Data Flow Task:
TITLE: Microsoft Visual Studio
------------------------------
The task with the name "Data Flow Task" and the creation name

SQL 2000 SP4 DTS
Windows 2003 Server sp1
We have two diferent packages (parent and child) to load text files.
The child package has a condition node that decides if all steps should

I have a problem with a DTS process which imports from excel to SQL. I have
tried this dts process on both SQL 2000 and SQL 2005, and they appear to
both be behaving the same odd way.
The DTS process never is able to pick up any data residing on row '1' of the

Hi. Here's what I need to do in a DTS package and don't know how: Insert all
the values from an Oracle view into a SQL Server 2000 table where the value
from the source doesn't exist in one of the columns of the destination
table. Thanks.

Installed an upgrade from 2000 sp4 to 2005 sp1.  Trying to import simple flat
file of 30,000 records but getting error that told me nothing.  Somebody
suggested installing SP1 on my local machine to get better error reporting,
which I did.  Now the error is a truncation error.  ...