You can use Derived Column transformation. Use Replace and try the expression:

ISNULL([ColumnName])? ".00":[ColumnName]

I haven't tried this myself by i guess depending on your datatype you can build your...

You need to replace the expression in Derived colums with what Ray has suggested.

Derived Column Name Expression ...

You cannot set an object type variable like this. What exactly do you want to set? Object types are generally used to store full resultset from a query or fill...

The best way would be use config files to store the connection string.

http://www.sql-server-performance.com/articles/dba/package_configuration_2005_p1.aspx

HTH

I am bit confused now, in your original question you said -

i have the column with the values like 453-5654-456.in the derived column i want didplay this one as...

Follow the link below for a quick intro to Interacting with the Package in the Script Task

http://msdn.microsoft.com/en-us/library/ms135952.aspx

HTH

I did a simple test and the same scenario works absolutely fine for me. Not sure anymore what the problem could be.

The only other thing that comes to my...

You can access the connection manager items using Dts.Connections collection. Try following to get the path of a File connection nanmed 'FileConnectionName'

Dts.Connections.Item("FileConnectionName").ConnectionString

You can thin use this to open and read...

What is the datatype of your SSIS variable? If its Int32 try to use LONG as datatype in Parameter mappings.

Yes you need to set the parameters for the Execute SQL Task and use select the variables as Input types. Not sure what type of query you are using but...

Check the datatype of the column in flat file connection. Also in the Derived Column Transformation when you get an errro (red expression), try to hover over it and see...

You can use expression to build this string. Set the EvaluateAsExpression property to true on your 'SQL' variable and use the following expression to build the string

"exec MyUSP @Date =...

I tested it in SSIS and it works fine for me. When you say 'Not working' - does it not give you the desired result or does it error?

If you...

Try

REPLACE(Col_Name,"-","")

You can your Row InputBuffer to access your entire row. If you want to update the row make sure in the chage the UsageType to ReadWrite.

Public...