I do not know how to do this. I took your string. Replaced the text User::xDate with xDate and placed it in as an expression in my derived...

I figured out how to do it in sql. How do you do it in SSIS derived columns.

Input is 3/1/2009 Output is 03/01/2009

SELECT

CAST( RIGHT(POWER(10,2) + CAST(CONVERT(CHAR(2),DATEPART(M, xDate),101)...

The app will only read it as char.

This was resolved. We installed SSIS Server on our file server and 'productleveltoolow' error was resolved. We did not need the SSIS enterprise version on my...

Thank you again.

As you suggested, I have made the derived column DT_STR and yes it worked. I did not need to change the table column from a char to...

Thank you for all your help.

I would like to add that the data from the source is all dt_str.

The issue w/ the unicode error is happening on the global variable....

I figured out why the error and I'm not sure if I corrected it.

I changed the type of the column on destination table from a char(8) to an...

I have removed it. That message went away and I am known getting the message

Error at Data Flow (OLE DB Destination) Columns "Derived Column 1", and CurrStatus...

I'm getting an error at pass variable.

In the derived column name I left the text "derived column 1".

In the derived column I left "add a new column".

In the expression I added "@[User::xCurrStatus]" This is my Gloval...

On the Data Flow Task, I added OLE DB Source and an OLE DB Destination. In between I have a Derived Column Transformation. When I open...

Thank you. My execute sql task (general) has the select statement. I then have the value go to a global variable (result set). I'm okay till point....

Okay. Continuing on. In the Execute SQL Task Result Set, I added the ResultName=CurrStatus and VariableName=GlobalVariableCurrStatus.

It passed the parameter. Know I'm trying to...

Package was created on my client (Visual Studio 2005 - version: 8.0.50727.762 (SP 050727-7600).

SQL Server Management Studio on my client is 9.00304200.

Note that I can run...