Hi, i make a SSIS Package which do the following things - 1. Connect with flat file source(CSV). 2. IMPORT all csv data to SQL Tables with derived column then i run a SP which do some changes in tables & push all data into Main Table. can this SP run through my package & data move to main table directly. Used Sp is this --------- ALTER PROCEDURE [dbo].[ADVENTIST_MEDICAL_CONSOLIDATE] AS BEGIN DROP TABLE [MI70_ADVENTIST_SOURCEDATA].[DBO].[TEMP_MEDICAL_CLAIM] SELECT [Und Nbr],[Grp Nbr],[Emp SSN],[Dep Seq] ,[Date of Birth (Patient)] ,[Clm Nbr] ,[Lines],B.[ClaimType],[ClaimNO],[ClaimStatus],[Incurred] ,[Received] ,[Processed] ,[PaidDate] ,[Charges],[NotCovered],[Deductible],[Coinsurance] ,[GrossPayment] ,[COB],[ADJ],[NetPay] into [MI70_ADVENTIST_SOURCEDATA].[dbo].[TEMP_MEDICAL_CLAIM] FROM [MI70_ADVENTIST_SOURCEDATA].[dbo].[ADVENTIST_MEDICAL_MEDCLAIMS] A LEFT JOIN [MI70_ADVENTIST_SOURCEDATA].[dbo].[ADVENTIST_MEDICAL_PAID_CLAIMS] B on ltrim(rtrim(A.[Clm Nbr]))=ltrim(rtrim(REPLACE(b.ClaimNO, '-','')))---1434857 END select CONVERT(char(6), convert(date,[From Date S1]),112), COUNT(*) from TEMP_MEDICAL_CLAIM group by CONVERT(char(6), convert(date,[From Date S1]),112) order by 1

Yes shure, you can use an Execute SQL Task after your Dataflow task to call your SP. Set the Connetion to your SQL Server, in SQLStatement add exec [dbo].[ADVENTIST_MEDICAL_CONSOLIDATE]

The SP logic can be written directly into SSIS package using Execute SQL Task.Vikash Kumar Singh || www.singhvikash.in