additional logg for DTS_DataPump Task inDTS Package

hi
any one knows how can log in a dts package othere than the defalt log .

i can work it out using DTSPackageLog.WriteStringToLog using a seperate activex task in my package .

the problem is that in my package there are more than 15 dts datapump tasks ,so to make log for each task i have to use 15 such activex task.......

so any one know how we can use DTSPackageLog.WriteStringToLog
or any thing similar in dts datapump task so that we can know the beginning and ending of individual task

abhiCheck this link (http://vyaskn.tripod.com/sql_server_dts_error_file.htm) from Vyas.

Adding Line after a Group

Hi all,
I am not able to add a line break after each Group. When I use (Add PageBreak after Group) property, each group is displaying in seperate pages, but i need to have groups continous with a line break between Groups.I greatly appreciate for the help.
Thanks in advance...

Hi,

Have you checked 'Page break at start' or 'Page break at end' in Group Property Dialog ?

Best Regards

|||Hi.....
What ever the Group Items text box...Row...First Complete Row..Then Property Window.....Border Style ......Select Bottom-Solid....
Ok Ur Prblm may Solve without any Page Break....

Best Regads...

Adding data from 2 seperate tables / data sets

Hi There
is it possible to add a total field from table a dataset a to table b
dataset b & finally, is it possible to do a calculation on those results.
(like a percentage of 2 fields)
i have an offered & answered column in one table & a messages played column
in another table with different data set.
i need to add the messages played to the answered column then give the
difference between offered & answered in the form of a percentage.
thanks in advance for assistance.best to do the join and math in the query
"Tango" wrote:
> Hi There
> is it possible to add a total field from table a dataset a to table b
> dataset b & finally, is it possible to do a calculation on those results.
> (like a percentage of 2 fields)
> i have an offered & answered column in one table & a messages played column
> in another table with different data set.
> i need to add the messages played to the answered column then give the
> difference between offered & answered in the form of a percentage.
> thanks in advance for assistance.
>|||Hi, I've the same problem as Tango
But, I can't join and math the query because one has a specific condition
and the other one has an other specific condition.
There's no solution to join 2 data sets?
Thanks in advance
"Antoon" wrote:
> best to do the join and math in the query
> "Tango" wrote:
> > Hi There
> >
> > is it possible to add a total field from table a dataset a to table b
> > dataset b & finally, is it possible to do a calculation on those results.
> > (like a percentage of 2 fields)
> >
> > i have an offered & answered column in one table & a messages played column
> > in another table with different data set.
> >
> > i need to add the messages played to the answered column then give the
> > difference between offered & answered in the form of a percentage.
> >
> > thanks in advance for assistance.
> >|||Not realy, you can put somthing like Fields!x.Value = Sum(Fields!y.Value,
"scope") where x and y are different datasets. But thats probably not enough.
However IMHO, I don't think you could join anything in a report that you
couldn't join in a query.
Select * from
(query1) a,
(query2) b
where a.key = b.key
should do the trick, I would think
"Nicolas BRESSAN" wrote:
> Hi, I've the same problem as Tango
> But, I can't join and math the query because one has a specific condition
> and the other one has an other specific condition.
> There's no solution to join 2 data sets?
> Thanks in advance
> "Antoon" wrote:
> > best to do the join and math in the query
> >
> > "Tango" wrote:
> >
> > > Hi There
> > >
> > > is it possible to add a total field from table a dataset a to table b
> > > dataset b & finally, is it possible to do a calculation on those results.
> > > (like a percentage of 2 fields)
> > >
> > > i have an offered & answered column in one table & a messages played column
> > > in another table with different data set.
> > >
> > > i need to add the messages played to the answered column then give the
> > > difference between offered & answered in the form of a percentage.
> > >
> > > thanks in advance for assistance.
> > >|||thanks,
the problem it's the same database but with different conditions.
I'll try your solution
"Antoon" wrote:
> Not realy, you can put somthing like Fields!x.Value = Sum(Fields!y.Value,
> "scope") where x and y are different datasets. But thats probably not enough.
> However IMHO, I don't think you could join anything in a report that you
> couldn't join in a query.
> Select * from
> (query1) a,
> (query2) b
> where a.key = b.key
> should do the trick, I would think
> "Nicolas BRESSAN" wrote:
> > Hi, I've the same problem as Tango
> >
> > But, I can't join and math the query because one has a specific condition
> > and the other one has an other specific condition.
> >
> > There's no solution to join 2 data sets?
> >
> > Thanks in advance
> >
> > "Antoon" wrote:
> >
> > > best to do the join and math in the query
> > >
> > > "Tango" wrote:
> > >
> > > > Hi There
> > > >
> > > > is it possible to add a total field from table a dataset a to table b
> > > > dataset b & finally, is it possible to do a calculation on those results.
> > > > (like a percentage of 2 fields)
> > > >
> > > > i have an offered & answered column in one table & a messages played column
> > > > in another table with different data set.
> > > >
> > > > i need to add the messages played to the answered column then give the
> > > > difference between offered & answered in the form of a percentage.
> > > >
> > > > thanks in advance for assistance.
> > > >|||You could also try subreports.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
> Hi, I've the same problem as Tango
> But, I can't join and math the query because one has a specific condition
> and the other one has an other specific condition.
> There's no solution to join 2 data sets?
> Thanks in advance
> "Antoon" wrote:
>> best to do the join and math in the query
>> "Tango" wrote:
>> > Hi There
>> >
>> > is it possible to add a total field from table a dataset a to table b
>> > dataset b & finally, is it possible to do a calculation on those
>> > results.
>> > (like a percentage of 2 fields)
>> >
>> > i have an offered & answered column in one table & a messages played
>> > column
>> > in another table with different data set.
>> >
>> > i need to add the messages played to the answered column then give the
>> > difference between offered & answered in the form of a percentage.
>> >
>> > thanks in advance for assistance.
>> >|||How we can make a subreport?
"Bruce L-C [MVP]" wrote:
> You could also try subreports.
>
> --
> Bruce Loehle-Conger
> MVP SQL Server Reporting Services
> "Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
> message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
> > Hi, I've the same problem as Tango
> >
> > But, I can't join and math the query because one has a specific condition
> > and the other one has an other specific condition.
> >
> > There's no solution to join 2 data sets?
> >
> > Thanks in advance
> >
> > "Antoon" wrote:
> >
> >> best to do the join and math in the query
> >>
> >> "Tango" wrote:
> >>
> >> > Hi There
> >> >
> >> > is it possible to add a total field from table a dataset a to table b
> >> > dataset b & finally, is it possible to do a calculation on those
> >> > results.
> >> > (like a percentage of 2 fields)
> >> >
> >> > i have an offered & answered column in one table & a messages played
> >> > column
> >> > in another table with different data set.
> >> >
> >> > i need to add the messages played to the answered column then give the
> >> > difference between offered & answered in the form of a percentage.
> >> >
> >> > thanks in advance for assistance.
> >> >
>
>|||Subreports work great for a 1 to 1 or a 1 to many relationship of the data.
A sub report is just a regular report with parameters (first get the report
working standalone). Then you drag and drop the report onto your other
report, do a right mouse click and set the parameter mapping. Read up on
subreports in books online.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
message news:A9582474-CB42-40D5-A605-3455CAE81518@.microsoft.com...
> How we can make a subreport?
> "Bruce L-C [MVP]" wrote:
>> You could also try subreports.
>>
>> --
>> Bruce Loehle-Conger
>> MVP SQL Server Reporting Services
>> "Nicolas BRESSAN" <NicolasBRESSAN@.discussions.microsoft.com> wrote in
>> message news:721271CD-50E6-4C20-A385-6DB090F8584D@.microsoft.com...
>> > Hi, I've the same problem as Tango
>> >
>> > But, I can't join and math the query because one has a specific
>> > condition
>> > and the other one has an other specific condition.
>> >
>> > There's no solution to join 2 data sets?
>> >
>> > Thanks in advance
>> >
>> > "Antoon" wrote:
>> >
>> >> best to do the join and math in the query
>> >>
>> >> "Tango" wrote:
>> >>
>> >> > Hi There
>> >> >
>> >> > is it possible to add a total field from table a dataset a to table
>> >> > b
>> >> > dataset b & finally, is it possible to do a calculation on those
>> >> > results.
>> >> > (like a percentage of 2 fields)
>> >> >
>> >> > i have an offered & answered column in one table & a messages played
>> >> > column
>> >> > in another table with different data set.
>> >> >
>> >> > i need to add the messages played to the answered column then give
>> >> > the
>> >> > difference between offered & answered in the form of a percentage.
>> >> >
>> >> > thanks in advance for assistance.
>> >> >
>>