Hi, everybody.
I am trying to transfer a database from one server to another using SSIS
Transfer Object task.
The package runs, but crashes with a quizzical error:

I want to know if there is a way I can make a DTS package log to an xml web
service and query a functions for data that i can insert into a table ?
thanks

As the subjects says i wish to find out if a spesific database exist in my
sql server.
I wish to write following statement.
if not exists (select * from information_schema.databasename where

Disclaimer ... I'm new to SSIS
I'm working on a project import flat files into Sql tables. My 1st two flat
file to Sql 2005 table SSIS packages are working great.  Wahoo !!
Anyway,  the next flat file has three CHAR(1) columns coded as either "Y, N

I'm trying to set up a SSIS package that will use columns from a flat
file and insert them into an existing table using an 'insert stored proc'
for the target table.  I keep getting an error that says I have to provide
inputs for all the stored proc parameters but the flat file only ...

I have a DTS that transform data between two databases on the same SQL
Server, as shows below:
table A  ====> table B
(database_1)   (database_2)

By default, are the sql statements in DTS in TRANSACTION?

I am having problems importing text values from an Excel file.  Numeric
fields are loading fine, however.  Below is what my spreadsheet looks like
APP_AGE
1                1

Is it possible to change the connections of a DSN dynamically via DTS?
I need to pump data to approx 100 different destination servers and am
hoping that it is possible to do this by simply changing the Server
name/IP of a DSN.  

How do I retrieve a package  which I saved during the import (using
import wizard)  in SQL Management Studio as SQL Server package???

What I want is a way for an Execute SQL Step to get access to a package
global variable so that I can do decisions based on it and I cannot figure
out how.  What I have is a global variable called "LogDebug".  I need this to
be used in an Execute SQL Task in the following manner:

I can run my dts package directly.  However, when I schedule the package as
job, I get the following error message:
Executed as user: WIN\cis50SQL. ... OnStart:  DTSStep_DTSExecuteSQLTask_1  
DTSRun OnFinish:  DTSStep_DTSExecuteSQLTask_1   DTSRun OnStart:  

Not 100% sure this is right group but here goes.
A lot of my exports from databases tend to end up in excel spreadsheets.
Which means I use the import function from Excel (Microsoft Query) and the
export to excel from Enterprise Manager, a lot.

I'm running DTSs from a Windows Service developed with VS2003 (.Net 1.1.).
I need to update some Global Variables values (in the same way I do with
parameter /A of DTSRun.exe).
Those Variables are String Variables. Those variables are used from a

I'm trying to create DTS package that would update database_2 with data
from database_1.
I've added both connections.
I've added a Transform Data Task.