Many thanks to both of you... Any suggestion on the book and best possible approach to learn SSIS please?

Brandie Tarvin & John Mitchell - First thing first... I am very sorry for wasting your time. It works with script task and it shows the date. I am kicking...

Also I wanted to check if I am doing this right... to test the variable, I am executing the specific task (Execute SQL Task) in my case and then after...

John - Thanks again. I had tried that yesterday and this morning.. however, I had tried the same after your recommendation. The package seem to execute without any problem but...

I am sorry for this confusion. I am adding to my previous post...

I had checked the variable scope and it shows that its package level scope. I had attached the...

Not only this query... even if I try to use...

SELECT 1

And if I wanted to pass the value 1 to variable it does not work. So I am very...

[font="Verdana"][font="Verdana"]Yes, it returns this value...

2011-04-01 00:00:00

I had also attached the sample data for your reference...

_______________________________________________________________________________________________________________________________________

_______________________________________________________________________________________________________________________________________

CREATE TABLE [dbo].[CurrPeriod](

[Carrier1] [nvarchar](3) NULL,

[Carrier1Name] [nvarchar](39) NULL,

[FlightNo1] [nvarchar](4) NULL,

[Carrier2] [nvarchar](3) NULL,

[Carrier2Name] [nvarchar](39) NULL,

[FlightNo2] [nvarchar](4) NULL,

[CarrDom1] [nvarchar](2)...

Just adding to my previous post... the scope the variable is package level.

Thanks - DV

Hi,

Thank you for your time. Here is what you need...

SELECT STATEMENT (Returns a date) :

SELECT Min(EffFrom) as MyDate FROM APE.dbo.CurrPeriod

I am also attaching the screenshots of Execute SQL Task window...

[font="Verdana"]Hi John,

I am creating a breakpoint after PostExecute Event. And then I am looking at the variables overiew window in BIDS and it shows the 0 value instead of the...

Thank you for the suggestion. I'll try the same... I wanted to understand why it can't work from a SELECT statement and I need to create a STORED PROCEDURE just...

Thank you very much for replying back. I am doing exactly same and I still can't get it working for some reason. I am very new to SSIS and I...

This is helpfull. Thank you!

[font="Verdana"]Good question. I am glad that I got it right! Although surprised to see many incorrect answers…[/font]