Please tell me what's wrong with this.
I have used multicast in my SSIS packages to write to multiple destination
relational tables and have had no problems...until now.
Basic processing flow:

I'm performing a string REPLACE(Column1, Column2, "") action on two
columns in a Derived Column DataFlow item. Column1 and Column2 are both
DT_WSTR with a size of 4.
But now I will get a validation warning:

I have a SSIS package called "MyExport" stored on the SQL server. I have
created an SSIS package configuration stored in a SQL table msdb.dbo.SSIS
Configurations, with the ConfigurationFilter = "Export2" with some
configuration values which I can change programmatically as needed ...

when I add some custom logging into my package + the default SQL logging of
the package, the GUIDs are different.
the Auditdtslog90 contain a column "ExecutionId" which is different from the
"ExecutionInstanceGUID " system variable!!!

does it possible to encrypt the DTexec command line like we can do with DTS
2000?
I don't want to display the password required to open the packages in a
clear text.

Hello NG,
I have a ForEach Loop Container which iterates recursively
over some xml files. The full filename (including the path)
is stored in a variable.

Does SSIS hold the last row number that a transformation failed on?
TIA

By using which driver can I convert DBF files to SQL Server 2005?
I'm using SSIS.
Thanks in advance,
Leila

Is there a way to validate a date in SSIS?
At the moment I've got
  LEN(TRIM(costdate)) == "" ? NULL(DT_DBDATE) : (DT_DBDATE)costdate
Which works if I could rely on costdate being formatted properly.

I need to pass into SSIS Scrip task parameter that has a type of dataset (or
table). This parameter was loaded in previous "Execute SQL" task.
I set value "ReadOnlyVariables" with my variable name that contains data
set.

When you have a Script component in a Data Flow, the Output0Buffer is not
accessible in Script Designer. Is there a Fix for this yet?  My VS2005 is up
to date... Do I need some sort of SSIS Update?
Thanks,

I'm having a problem with a Send Mail Task in my SSIS package. The mail
server that I'm using to send the email out on is giving me an error:
Send Mail Task: An error occurred with the following error message: "Command
not implemented. The server response was: Use helo/ehlo first ...

I am new to SSIS and haven't gotten in to it yet but so far haven't found
the answer to the following questions.
We have several DTS packages we have created which did not involve SQL
Server. They were Oracle and / or Pervasive.

Our Web Dev Team wants more current data on the development machine.
Is there a Slick way to copy the Data from all the Tables in a DB on Server
A to the Existing DB on the Dev Server?
In SQL 2000 we had a DTS job that did a DB Copy, though ran into issues when

Repost from 6/13 since I've had no bites on it.
I'm automating data mart population using Visio as a data source.  The first
step of this undertaking is to translate the visio diagrams into XML
equivalent.  I defined a schema around this xml structure and of course, it