I want to call a sp in DTS, where SP return output from a #temp table. Its
not working . Is there any other way

I have 200 mil records in one table need to be transferred from one server
to another server fro test.What is the best way to do the transfer by
passing the log?
Select into?

I'm have a DTS package that imports a text file into a SQL 2000 db. My
problem is that one of the fields in the text fil contains a price with
comma as decmal separator.
The text file:

Is there an easy way to dynamically configure DataFlow tasks in your
package? For example, I'd like to be able to pass in a variable for the
name of the source and destination tables, and have the package read
the metadata for these tables in the dataflow task.

I have 2 servers: one is WebServer, the other is DBServer
SQL Server is installed on DBServer, I created a DTS (exporting from table
to Excel file), the destination file is on WebServer( \\WebServer\aaa.xls). I
successfully run the DTS in Enterprise Manager, but failed when ...

I have a script task that generates Foreign Key drop and create scripts.  The
output of the task goes into variables.  I have this task in its own package,
and can successfully pass input variables to the child package from the
parent package.

I work for a poultry science company and we generate about 15 csv files per
day from an egg scale we use to grade and package.  One csv file is one
record, and each row represents a field much like a column does in a table.  
I believe it's called a line-dependent csv.

I am converting a 2000 DTS script to SSIS and am having a problem in figuring
out what approach to use in a specific task that I have. I previously did
this with a transform data task.
I am tring to copy data from an analysis service cube to sqlserver2005 using

I deleted a dts package and need to restore it. I understand that the package
should be in the msdb table, but id not. We do backup the server to a tape
backup, but I do not know where the dts packages are stored. Is it in the
msbddata.mdf file? If so, if I retore just that file, is ...

I was wondering if there was a way to further examine a redirected rows
from a lookup?
For Example:
If I have a lookup comaring two sources (Flat File against a DB Table)

What is the best way to remove trailing spaces in a dataflow in a SSIS
package?
The SRC OLEDB connection is to a Visual FoxPro DB - all of the columns
in the tables are CHAR so trailing spaces are included in the dataflow.

I have 1 to n Excel spreadsheets I need to load to SQL tables.  Excel
files names are table names in database and Excel column names are
table columns.  I need to check if table exists in db, rename existing
one to name_bak, create a new table and insert data into it from Excel.

I am trying to port a job where there are several DTS packages in various
steps being called from cmd.  How can I identify what package names are
associated with what job step so I can move the DTS packages as well?
thanks

The connection for a Check Database Integrity Task allows selection of
specific databases. However there appear to be no equivalent configuration
properties for these selected databases.
Is there a workaround for this? (Preferably not editing the dtsx files or

Our server crashed and I'm in the process of re-installing everything.
We use SQL 2000 and I have all the databases from backup.
I now have about 50 DTS packages that I need to open and save into SQL.
Is there a way to do it so I don't have to manually go through 50 DTS