Sri8143 (7/5/2013)

---

Implement a function with below logic in an efficient way ...Pass @var1 and return @var2 ...How can it be done as it does table scan now ??

DECLARE @Var1 VARCHAR(10)

DECLARE...

No problem.

Within the SSIS data pipeline, there is not really a concept of table names. The source data values are copied to in-memory variables which then flow through the pipeline...

(clutching at straws...)

One thing worth checking: try changing the tilde (~) to something else (eg 'x'), just in case it is being interpreted as a special character. It does have...

Hmm - that should work.

Can you attach a screen shot which shows the data flow along with the derived column expression?

As long as the derived column is somewhere between your...

Try changing your expression - you do not need the 'select' bit. See here for reference.

Also, note that literal text should be surrounded by " rather than ' in SSIS...

What is this all about?

If your question is about SQL 2008, why not post it in that forum?

If your question is about T-SQL, why post it in an SSIS forum?

What...

Nice work, well done.

Animal Magic (6/28/2013)

---

OK cheers. One theory I do have is setting 3 data flow tasks all output to different files which have the same output path, hence windows seeing them...

I would probably use a Script Component to do this - with a single output column.

The Script Component then needs to take care of adding all the delimiters and performing...

Are the header and footer static or dynamic?

I just had a look at this. I can build a dynamic pivot to get you either 'report count' or 'report pending' figures - but not both on the same...

OK, you need a dynamic pivot in combination with some sort of date tally - that's a bit of work. I'll try to get back to you a bit later,...

suryam (6/27/2013)

---

Actually client is going to spool this report on the basis of between transaction dates how many processed and pending according to branch and region wise. like bangalore for...

suryam (6/27/2013)

---

Thanks Phill, for your great suggession.

now here below are my table details

/*************/

create table #Mis

(

region varchar(50),

branch varchar(60),

trdate datetime,

reportcnt int,

pendingcnt int

)

insert into #Mis values ('Bangalore','BG40-BELGAUM','2013-05-06 00:00:00.000',0,1)

insert into #Mis...

You're not new here & should know the drill by now.

Please see the link in my signature - we need consumable DDL and INSERT statements to make it easier for...