Try the following:

(FINDSTRING(TRIM([STARTD_CVV]), "-",1) > 0) ? NULL(DT_STR, 8,1252)...

itsaditi2001 (7/15/2010)

---

But i am Novice to SSIS ..Can you tell me how to do it in derived columns ..what about the other columns ..they also need conversion ..so can i...

:blink:

I think I have an URL where you can download experience. If I can find it,...

That is because that is not the purpose of those methods.

The ORDER...

I don't think it is a good idea to build your connection string with getdate().

Since getdate() gives you the current timestamp, it will always change when you run the package...

Do you get any errors/warnings?

Are all the permissions set up correctly?

Are you sure it is not a permission issue?

Also, in production. is there only a warning or also an error? How does it fail?

I believe you are in the wrong forum. This is a forum about Microsoft's Business Intelligence suite on SQL Server.

You should try a dedicated Cognos forum.

(and I don't believe you...

OK, then why don't you store the child package names in a table, read the table and loop over a Execute Package Task with a for each loop (using expressions...

I got it wrong because I overlooked the semicolon.

I was focusing more on the use of subqueries with count in a query, which I thought was the point of this...

Indeed. That's why you need to point it to a test file (with the same structure) during design...

I have succeeded many times. Use the ExcelFilePath property as mentioned earlier, with the expression you build in the beginning.

When you start designing, configure your excel connection manager by pointing...

re·dun·dan·cy (r-dndn-s)

n. pl. re·dun·dan·cies

1. The state of being redundant.

2. Something redundant or excessive; a superfluity.

3. Repetition...

You are trying to set the wrong property.

With the expression that you created you should set the ExcelFilePath property.

The connection string has the following form:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source="\\myServer\myExcelfile.xls";Extended Properties="EXCEL 8.0;HDR=NO;IMEX=1";

which is a...

A simple question, but a usefull one nonetheless, especially if you use the function with variables as input parameters.