Hi All, When I run the following query on SSMS , it works fine. SET NOCOUNT ON declare @FileName nvarchar(1000) declare @RejCd int declare @TableName nvarchar(1000) declare @sql nvarchar(1000) declare @sqlscript nvarchar(max) set @FileName ='[dbo].[SUB_REPORT]' set @TableName ='[dbo].[SUB_REPORT]' set @RejCd = 1 set @sqlscript='SELECT * FROM [dbo].[SUB_REPORT] WHERE DATEDIFF(D,REJ_DT,GETDATE())>=3' select @sql = 'bcp "'+@sqlscript+' " queryout Y:\MyFileFolder\'+@FileName+'['+Convert (nVarChar(10) , ''+@RejCd+'' , 120 )+']'+ Convert (nVarChar(10) , GETDATE() , 120 )+'.txt -c -e -t, -T -S 1xx.18.2xx.1x1' exec master..xp_cmdshell @sql But when i run the same query with following changes in ssis package , i get an error message. I inserted this code in execute sql task. Input parameters for sqlsript is varchar type. Parameter lengh is -1. SET NOCOUNT ON declare @FileName nvarchar(1000) declare @RejCd int declare @TableName nvarchar(1000) declare @sql nvarchar(1000) declare @sqlscript nvarchar(max) set @FileName =? set @TableName =? set @RejCd = ? set @sqlscript=? select @sql = 'bcp "'+@sqlscript+' " queryout Y:\MyFileFolder\'+@FileName+'['+Convert (nVarChar(10) , ''+@RejCd+'' , 120 )+']'+ Convert (nVarChar(10) , GETDATE() , 120 )+'.txt -c -e -t, -T -S 1xx.18.2xx.1x1' exec master..xp_cmdshell @sql but then i get this error message. Can anyone help me to fix this pls? [Execute SQL Task] Error: Executing the query " with the following error: "Multiple-step OLE DB operation generated errors. reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. Possible failure Check each OLE DB status value, if available. No work was done." shamen