I am working on package to pull data from google analytics source. Where I need to loop through all the sites in the account for the dates I mention.

Right...

Yes. But the execute sql task is working fine , runs good. But no idea if it is returning any data or not.

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.