i load data through ssis pkgs, source and dest both are sql server databases, this is done every month.

i load fresh data every month about 50GB.

any thgouts on this process or is there a scopre fro improvement ?

i get this..

ohh yeah, there is no file in there? any other way to do ?

Andrew

Could you please how you pre prepared for the exams ?

do we get any books dedicated for this preparation?

can we beleive some online question banks which gurantee passing exams...

Actually i am not trying to capture the result but the message's in the result pane

OK, my running the below query it solved my problem.

SELECT p.name, p.folderid, f.foldername

FROM dbo.sysdtspackages90 p JOIN dbo.sysdtspackagefolders90 f

ON p.folderid = f.folderid

An example for moving packages from the MSDB...

how do i do left join on multiple columns ?

I dont see any kind of error mesgs any where. Can you some one please look into my option above help implementing that.

I dont think that will work in my case because its not just model database sometime it stops at user databases too but very rare which atleast proves that problem...

I just need to know how many recrods updted on which table and value from the coumn "state"

I want to insert them into a audit table (Tablename,RowsUpdated,State)

Moderator.... please delete this post.

Thanks you

Every time i import data (more than 100 million records) through wizard i get comminication link failure error from one server to another, is there an easy ans fast way...

Thank you so much guys.. appreciate all your replies for my post.

As Lynn said actually it was my fault not giving the datatype in the post but anyways this helped...

great, Lynn's query

worked for me.

For the same real data type how would i update 2008.1,2008.2......

with...