http://msdn.microsoft.com/en-us/library/ms141232.aspx would be a good start.

HTH

~Mukti

Sorry I didn;t read properly that the datatype of origDate is float. You may try this

SUBSTRING((DT_WSTR,8)[origDate],5,2) + "/" + SUBSTRING((DT_WSTR,8)[origDate],7,2) + "/" + SUBSTRING((DT_WSTR,8)[origDate],1,4)

This expression first casts origDate into...

Expression in SSIS work bit differently. Try the followin

RIGHT("00" + (DT_WSTR, 10) DATEPART( "mm", [origdate]) ,2) + "/" +

RIGHT("00" + (DT_WSTR, 10) DATEPART( "dd", [origdate]) ,2) + "/"

(DT_WSTR, 10) DATEPART(...

If you are using migration wizard it must have converted it into ssis. If you connected to Integration Services then under Stored Pacakges you will find your migrated packages under...

First create a ssis variable e.g. vSQL. Set the EvaluateAsExpression property = true for this variable and the expression put

"BULK INSERT #MTSA_PCS_RFO_temp FROM " + @[User::vFileName] + "WITH (ROWTERMINATOR =...

Try this:

Replace @[User::xDate] in the following expression with your column name ( i m using a variable just for example)

RIGHT("00" + (DT_WSTR, 10) DATEPART( "mm", (DT_DBDATE) @[User::xDate] ) ,2)...

Create a file connection to Package2 and in the Execute package choose File instead of sql server and select this file conneciton. It should then open the other package...

Where are you setting the ExcelFilepath?

And just to doublecheck you are setting the delay validation trur for DataFlow task where this xls file is going to be used as...

Yes its trying to validate. set Delay Validation to True for the dataflow where you are using the Excel file.

One more point, you can set the expression for ExcelFilePath...

Check Package configuraitons to see if the package is using config file/table to get the list of recipients to the email.

Not sure why you would want to do that, but try to put delay between the create and delete. you are right its not releasing the handle to the file...

In the flat file souce - check the following checkbox

Retain null values from the source as null values in the data flow

I haven't tried myself but give it a try...

you need to use double quotes instead of single in your expression. Try:

REPLACE( [Account] , "0", "" ) and it should get rid of all the zeros.

I guess you are using OLE DB connection. If yes, then use

Parameter Name : 0

Parameter Size: -1 (Defaul -leave as it is)

Follow this link for more info about paramater...

From the following article

http://www.sqlservercentral.com/articles/Integration+Services/65473/[/url]

1. Checkpoint can be implemented only at the control flow not to the data flow. This means that in case of failure in middle of the data...