CREATE TABLE [dbo].[SampleExcel2](

[CustID] tinyint NULL,

[TxnID] tinyint not NULL,

[TxnTime] datetime NULL,

[Amount] int NULL

) ON [PRIMARY]

INSERT [dbo].[SampleExcel2] ([CustID], [TxnID], [TxnTime], [Amount]) VALUES (1, 1, '6/1/13 12:30 AM', 900)

INSERT [dbo].[SampleExcel2] ([CustID], [TxnID], [TxnTime],...

@steve-2 - thanks for replying. But your query gives me a different result. Your query gives me the number of TIMES custA's status was changed (Ex: custA status1,...

The default date parameters are last 7 days and it should not be changed. However, I came up with another workaround which I figured out after playing around with it...

No worries. It was a permission issue and my DBA gave the necessary permissions and it is working fine now.

what is the error message on the subscription?

For subscription sending email, in reportmanager, status says "Mail sent to ......." and I never got the email (checked junk folders as well).

Fpr...

Thanks, Phil. I did that already, It gives me an error 'The configuration file name .... is not valid. Check the configuration file name.

Thanks to all.

Hi Niraj,

Thanks a lot for replying. You understood the requirement correctly. For parameter values, I have two datasets - one for default values (A,B,C) and one for available values ...

Thanks for replying.

Thanks for replying. Datekey and the field it is matching is date only column (no time is being mentioned).

The data will get loaded once every week. Job that runs this SSIS package is set in such a way that the job will run once in a week and...

Any idea how to handle this date key. Also, the table doesn't get cleaned before it gets filled. So, I don't have to truncate the table.

I need to have the data from all three sources added at the same time and there shouldn't be any lag between them. You mentioned that the data flow should...

You understood my requirement correctly. Apart from data flow task, is the package not going to have anything??? is it going to be that simple??? Please reply.

Also, I wanted to mention that in my query source data is coming from three different servers and the destination is only one table. If I choose data flow, then...