Thanks Gsquared ...Yeah we have a function with return value ....i found out now ..

thanks sarang and collins i am done with that but now i have an other issue ....

i have got a string (32323,3232,32,3232) i have some lookup tables for this...

thankz guys....

http://blogs.msdn.com/sqlperf/archive/2007/05/11/implement-parallel-execution-in-ssis.aspx

I believe you should change the max executable threads to 12 in the package properties ...

thanks jack got it .....

Dim oFile

oFile = FSO.GetFile(CopyFromSpec)

oFile.Name = CopyToSpec

Hello Jack but where exactly should i use this code as i dnt know much abt vb....plz let me know...in this code it doesnt...

Thkz a lot ....lynn

I am not an expert in that so i couldnt even know what exactly the error says

You can use for each loop for this. You can put a filter such as xbuns.??? . Use this in the File text box in the collection tab of the...

Hi could you make it much more clear by telling us what exactly you need so that everyone can help you ....if you want to change...

USE [KMS_GSK]

GO

/****** Object: Table [dbo].[GSK_MAINFRAMES_CHRGBACK_CUSTOMER_TRANSACTON] Script Date: 04/23/2008 12:29:41 ******/

SET ANSI_NULLS ON

GO

SET QUOTED_IDENTIFIER ON

GO

SET ANSI_PADDING ON

GO

CREATE TABLE [dbo].[GSK_MAINFRAMES_CHRGBACK_CUSTOMER_TRANSACTON](

[NDC] [varchar](11) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,

[CustomerID] [varchar](255) COLLATE SQL_Latin1_General_CP1_CI_AS NOT...

But if i have used some joins what would be the query let me post the query which would be easier for you ....

select km_ndc,custno,custnm,wholesaler_dea,wholesaler_name,null,null,

cd.sourcefile,null,qtrstartdate,qtrenddate,

case when sum(qty_corrected) =0 then sum(Qty_submitted)

else...

SELECT

km_ndc

,CASE WHEN (extended_amount_corrected)

+ (qty_corrected)

...

All rows for each km_ndc. If you want it for each individual row, then remove ALL of the SUM()'s and remove the grouping.

but if i do this way it...