Thanks all for your reply......

Hi,

I just came accross with one more question regarding lookup to do CDC....

now as I have to do an Insert and an update in the same DFT, what are the...

@@MrsPost

And incidentally - using "bcoz" instead of "because" falls into one of my pet peeves. Spell out the words and spell check when you're posting anything in public....

siddaiah.k,

I really dont have any specific answers written to all the questions i posted above,

I posted the topic because I wanted to get the answers from all of you as...

yes, this is the only error I am getting..

The execute package task is failing but as I am running directly the package I can clearly see that the underlying package...

Hi

Thanks ...but is there any way to hide your passwords when you deploy or move your packages from one environment to other..??????

Thank u all for your valuable inputs....

Lets jump to another question:

How did you deploy your packages?

In this queston what is suitable as we dont deploy and use manufest...

Hi

I got the same error in my master package but the underlying package executed without any errors....

I mean the EXCUTE PACKAGE TASK WENT RED(Error)

but the package that it was...

Hi thanks a lot for your valuable inputs...

I still have doubts about BEST PRACTICES...

I mean I say that we can use NOLOCK, we can ue select queries in OLE SRC,...

Hi,

Thanks for your reply, I always try to do that but still....:hehe:

Can some one provide me some answers to Questn Number

4

5

and 8

As I am really confused about what to answer.

Thanks

Hi,

If you want to insert using an Execute SQL task you can use the 4th option EXPRESSIONS, and Use property

SQLSTATEMENTSOURCE to write you insert query and use variables in it...

Hi,

I think you didnt get my question, actually already I am allowing NULLS for both the dates (from and TO) but the problem is in controlling this property based on...

Hey thanks man...ur code works like gem...

thanks again.........:-)

Hi Thanks For Your Reply Actually Thats What I Want , I Wanna Store Count 0 Values In One Test Table And Use Data From That Table If I Dont...

Hey Thanks Jeffery ...:-):-)

I just used unpivot in the query you provided and got it the way I wanted in one column....Thanks again:-)

Declare @curYearStart datetime

...