I have a DTS Packag that copies tables from one server to another.  Is there
a way to add a new table to this package?  I have not been able to figure
this out with the help of BOL.
TIA,

Can I add the date to the file name when I export SQL data using a Dynamic
Properties task.
LP

Hopefully just a quickie.
When just importing tables and their data, is it better to use seperate
source & destination connections for each table, to run the process in
parallel, or to use a "Copy SQL Objects Task" to include all tables?

I have 3 sql servers running.
lets call them sql server 1,2 and 3
all 3 servers have a table with the following columns
ID, Location, transaction id.

Okay, I have 4 tables that I need to load data into.  I was thinking of using
DTS to do the data load.  The 4 tables already exist with old data.  Some of
the data in the text files is the same as the data in the tables.
I have tried to disable to contraints on the tables and ...

I currently use Transform Data Task to load data into a tbl. The source data
is a select stmt. I'd like to make the db names used in the select stmt
dynamic/varaible. I've unsuccessully tried using input params in the sql stmt
(the source tab). Also considered using an SP for the ...

I need to build an extensive DTS package and my experience is with simple
DTS techniques only.  I like books that start with simple but include
advanced.
What would you reccomend?

Hi Gurus
We are trying to use linked server to oracle.
A simple insert of 100 rows is taking 3 minutes,
If i do bcp out and sql loader in to oracle it is just few seconds.

I am using the DTS wizard to export data from a table to a CSV.  I have a
varchar(7000) field that is getting truncated around 255 charachters.
Is there anyway to work around this truncation, so I am not losing
information from this field when exporting to CSV?

Can any one tell me how to copy the DTS Packages from One server to Other
Server. Both of My server are at on  different machines.
Thanks in advance,
siaj

I'll be the first to admit, the title for the post isn't the greatest but
didn't know what else to write. Anyways...
Im importing data from Excel into SQL. My StoreNbr coulmn can be in General,
Text, Number, etc... take your pick, the problem still persists.

I need the ability to export any sql statement or stored procedure (with
parameters) to an excel file at will. Anyone know how to put that into a DTS
package, or know of a premade one available somewhere?

I am going crazy over a load job,
I am loading few tables from one sql server to another sql server, for that
i created a DTS package, it was running fine until recently, all of a sudden
it started giving me problems.

I am experiencing performance problems with an aplication running over a SQL
Server 2000 Database. The server that holds SQL Server has 2.8 GB of RAM
memory. When there are just on or two users working, the aplication
performance is suportable, but when more users are using the ...

I have a DTS package that contains a "Execute Process Task Properties".
the task executes a Vb.Net exe file.
I am trying to pass a value from the DTS package to the vb.net exe
file/app. However I do not want the console to open and wait for my