The available event types in Event Handler is really exciting comparing with
DTS, but I cannot find OnSuccess or OnComplete events. How can I use them?
Thanks in advance,
Leila

When I click an item in Data Flow surface, red and green lines appear. I use
the green one to connect items to each other but I don't know what the red
one is. I need some clarification.
Thanks in advance,

I'm trying to use query parameters with an Oracle OLEDB Source in a data
flow task and I'm having problems.
I've tried formatting the query each of the following ways...
--

the SSIS-Package or jobs failed due to the ignore duplicate key message. How
do
I turn this dup key message off or ignore it so that the jobs will succeed?
Thanks,  psychodad71

Which edition of SQL Server 2005 includes the fuzzy logic of the Integration
Services?
Thanks
Klaus Aschenbrenner

There're a lot of samples of executing SSIS package using VB in MSDN. But  
this samples doesn't work in VBA.
DTS.Application doesn't contain the method LoadPackage (specified in MSDN  
sample), DTS.Package.LoadFromStorageFile failed with "The specified file  

The purchase decision of SQL-Server 2005 depends on the realization of the
following scenario:
- SSIS Package
- file watcher task on a special folder

I have a package that I wrote in SSIS that extracts data into a csv file,
then runs code to email this file.  This runs great within SSIS.  I have
built the package, and created a job to run that package.  The issue occurs
when I try to run the job, it fails with the following ...

how can I replace Fields containing NULL (if null then insert "99" else use
the value in the column) with e.g. "99" using SSIS. I think, that I should
use "Derived Column" and the ISNULL function, but i don't get the syntax.
Can anybody help me?

   I get the following error when I try to view any jobs in the MSDB folder
under Stored Packages for SSIS, can any help with this problem?
   The error is listed below.
TITLE: Microsoft SQL Server Management Studio

Is it possible -- and if so, how -- to have the "suggest data type" on a
flat-file source analyze more than the first 100 rows? I don't want to write
a program just to accurately size a flat file before using it a data flow.
Thank you,

I have an application I am building for loading our data warehouse.  One of
the sources of data has a flag that shows if the data is current or not.  I
don't want to run the package that changes data in the datawarehouse if the
flag is not set since it would corrupt some of the ...