Chris, reading this has made me feel queasy :sick: :hehe:

Something like this?

with msgTypes as (select distinct msgType from #t1)

select m.msgType, ADAM = a.MsgType, CDM = c.msgType

from msgTypes m

left join #T1 a on m.msgType = a.MsgType and a.Provider = 'ADAM'

left...

Do you know in advance what the column names will be? That is, does this have to be a dynamic query? The static version is easier to write ...

KoldCoffee (6/5/2013)

---

The field remains red. The field goes black if it is parsing. Well folks, it appears that, none of the regulars on this forum know how to write SSIS...

I don't like it either, but can't see any way of turning it off.

I know it's a bit OTT, but I've actually written a program to automate certain 'tweaks' to...

No problem & post back with any specific questions about the implementation. It takes a while to get to grips with the SSIS way of doing things.

No problem - it's pretty much the same as I described in my previous post.

The ExecuteSQL task will run the proc.

The proc will return a result which can be stored...

That's nice & easy.

Here's one way:

1) Create an integer package variable - say NumRows

2) Create an ExecuteSQL task to get the table's rowcount & return the result into NumRows. (You...

jampabsatish (6/4/2013)

---

Hi Brandie,

I'm facing the same issue but not able to figure out wt the issue is .

Im attaching a screenshot of the same error i got . could you...

Is there a chance that any of the values in pehPErcontrol is not a valid...

Ah - sorry - that came in a later version of SQL Server.

Try 'datetime' instead of 'date'.

select cast(left('201301042',8) as date)

Here is a small piece of code to back up my assertion that this is a datatype problem:

if object_id('tempdb..#ex', 'U') is not null

drop table #ex

create table #ex

...

If field2 is a datetime, trying to return 'nothing' if it is null will be giving the database engine a headache in terms of mismatching data types.

Instead, maybe try returning...

I just created a text file to check this. It parses for me.

--Edit: added screen shot