🙂 Thanks for the info...

I was expecting you'll suggest some best ones....

Thanks,

Regards,

Ami

Thanks,

Is there any blogs / articles to know more about it?

Thanks,

Regards,

Ami

one more update, the log file size is 30 GB..

thanks!!

Regards,

Ami

can we do that in a subscripted replication database?

will that affect replication?

Thanks.

But how to get rid of current big log file?

Regards,

Ami

thanks for your assitance,

though it is a production db. we don;t take log back ups as it is dwhse.

we have another db where one month of data will reside...

That said, it is a good practice to separate your backups from your SQL Server program,

white paper / blogs on the above comment.

-Ami

Thanks for your reply.

but i searched net to add value to that comment. i'm not finding one. is it mentioned in any MS sites or any white paper...

hi,

thanks for your reply. but how can i limit my records in Data Source view?

It is

cluadmin.msc

hope this helps,

ami

my question is how to bring the year(mth) from the transformation and how to put the same in expressions of flat file connection?

in flat file conn i can't get the...

MONTH(mth) == 1 || MONTH(mth) == 2 || MONTH(mth) == 3

MONTH(mth) == 4 || MONTH(mth) == 5 || MONTH(mth) == 6

........

using the above statement i'm finding out the QTR info...

yeah, that is working quite fine. and if i put that in a script task that also works fine. 🙂

still, want to try that in SSIS 😀

and sorry...

Hi Paul,

that can be done in a stored procedure. but how about doing the same in SSIS?

i expect this to be done using for each loop and inside that...