DataEnthusiast (9/9/2014)

---

Hey guys, here's an interesting scenario I encountered which I believe will be useful for all of us.

Problem Statement:

The flat file souce should pick the file with keywords matching...

rena24 (9/9/2014)

---

Hello everyone,

I want to ensure something. I must insert some files in my SQL Server Database. I use the traditional way. Oledb connection to SQL Server and fast load....

Talking...

pgmoschetti (9/9/2014)

---

Thank you Phill. What I know about the client is as follows:

- it's a SCADA software (Citect SCADA)

- the SQLExec is using ADO.NET behind the scene

- the four SQLExec...

This depends on how 'SQLExec' is implemented. More details needed about that before we can answer.

Please explain why not.

I thought you wanted Comp A,...

Perhaps something like this?

BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp " + BASIS_IND : "Comp"

You might need to use & instead of + to concatenate the text - can't...

There is no need for a...

The basic syntax is as follows:

boolean_expression?expression1:expression2

Your expression

BASIS_IND == "A" ||BASIS_IND == "T" ?: "Comp A": "Comp T" : "Comp"

has an 'expression3' - which I imagine is causing the error. (In...

Try removing the first question mark.

vijayalakshmii.venkatesh (9/5/2014)

---

I have a exec file which takes multiple input variables and produce output in the form of Table.

Can I achieve this through Excecute process Task...

If you remove the AND clause completely, are the required rows displayed?

Please do a SELECT from dbo.cdbAttribInst showing the value of ainAttribID for the rows you want to appear and...

There is an SSIS System Variable called 'StartTime'.

You may be able to create an Expression which uses this, thus avoiding the need for a Script Task.

cstrati (9/5/2014)

---

Hi Phil

Thanks for your reply.

Unfortunately I've ran your script and I'm getting the same 4 results.

It doesn't appear that the columns that are emtpy display when adding 'Null'...

Also, if lots of data is involved, that WHERE clause is going to tax the database engine because of all those function calls. We may be able to help optimise...