crever is correct that one option would be to use a SQL table to communicate between parent and child packages.

You can also use Package Configurations to pass data...

I'm not sure what you are asking for here? Are you looking to view the connection properties for a given SSIS package in XML format, or are you looking...

The SQL Server REPLICATE function also works well for this type of requirement:

The following example will take a value @strOldValue and pad it to 50 positions, right justified, padded with...

Glad to hear you got the issue resolved.

Yeah casting values correctly has caused me problems in the past as well.

I don't understand why this is not rendering as a valid expression. I assume it appears in red when you paste it into the expression column? When you...

You cannot output to 2 columns using a single expression in Derived Column Transformations. Here is what I used locally and got it to work fine. It adds...

Can you please be more specific on the error you are receiving?

FINDSTRING is one of the valid SSIS string functions. If you expand the "String Functions" folder in the...

You need to use SSIS scripting inside derived column tasks. Try the following:

FINDSTRING( [Description] ,"TDt",1) != 0 ? [Assessment_Date] : "0"

Set the Derived Column Name to

Date

Sorry, I mis-read your original question.

You are within the data flow pipeline, so the logic you use applies to each record you are reading.

Here are a couple of things you...

Are you typing your script within the following section?

Public Sub Main()

...

End Sub

SQL Server Agent in SQL Server 2005 runs a lot different then you would expect. I've run into this same issue before and surprising "sa" does not have all...

Actually, depending on the encryption of the package strored in SSIS, you may be able to export this package from SSMS Intergration Services to a .dtsx disk file, create a...

use msdb

select *

from dbo.sysdtspackages90

order by [name]

If you search for sysdtspackages90 in BOL it will give you the definition of these columns.

--The folderID can be found in

select *

from sysdtspackagefolders90

Assuming the database tables all have the same format, you will need to initially point to one of these tables in your data flow. Once you have completed this,...

I have no idea what 0 (Default client) for packagetype means. Here is the list of values from BOL but I couldn't tell what 0 means..

The client that created...