The Data flow is not working , as the DB2 is a stored procedure with paramters.

Inside script task , I first create a text file to the path "D:\....csv"

my code in c#

public void Main()

{

...

Something like below.

DECLARE @ReportStartDate DATE = '07/01/2015'

DECLARE @ReportEndDate DATE = '07/01/2015'

--staging tenp table creation

IF OBJECT_ID('tempdb..#FinalOutPut') IS NOT NULL

BEGIN

DROP TABLE #FinalOutPut

END

CREATE TABLE #FinalOutPut

(

Asdfg VARCHAR(60)

,M_id VARCHAR(100)

,GP_id INT

,C_id int

,Dt_modified DATETIME

,UID VARCHAR(50)

)

IF OBJECT_ID('tempdb..#EC')...

The query has parameters and create and update statements in it and parameters , when i try to run the query in OLEDB sql command source , the parameters...

The above query pulls data from another source , where i can only read data not write. I need to run this query and pull the data and insert it...

Here is the query format. I could not get you orginal query but this is the format of it.

DECLARE @ReportStartDate DATE = '07/01/2015'

DECLARE @ReportEndDate DATE = '07/01/2015'

--staging...

If i schedule it to run daily through subscriptions ( ssrs), in SSRS, report will run daily but populates data only on that particular day( checking condition if today is...

I can get the last quarter date.But need to add subscription to run after 110 days after last quater.

NO Problem.I got it.

I know , it's kind of DBA questions and they are excepting the Developer to answer it and I am a Newbie to SQL server ,and never faced such situations...

Sorry the questions is like this: Design a table, how to track phone call.

I was doing that , but I need to run only on Business working days.So I took calender table to run only on business working days.

Thanks,

Komal

Thank you ray.IIf worked for me but switch is not working.

Hi here is the example:

DROP Table #a

DROp Table #b

Create table #a

(

Col1 int

,COL2 varchar(10)

)

Create table #b

(

col1 int

,COL2 varchar(10)

)

insert into #a

Values (1,'Y')

insert into #a

Values (2,'N')

insert into #a

Values (3,'Y')

insert into #a

Values (4,'N')

insert into...

I did something like this below:

DECLARE @COPYDATE datetime

,@COPYDATE_END_OF_CURR_MONTH varchar(50)

,@COPYDATE_END_OF_1_MONTH_AGO varchar(50)

,@COPYDATE_END_OF_2_MONTH_AGO varchar(50)

,@COPYDATE_END_OF_3_MONTH_AGO varchar(50)

,@TODAY DATETIME

SET @COPYDATE = '10/31/2012'

SET @COPYDATE_END_OF_CURR_MONTH =convert(varchar(50),DATEADD(DAY,-1,DATEADD(MM, DATEDIFF(M,0,@COPYDATE)+1,0)),110)

SET @COPYDATE_END_OF_1_MONTH_AGO = convert(varchar(50),DATEADD(DAY,-1,DATEADD(MM,...