If I want to use DTS export table to Oracle from SQL Server, what all
drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
Does any other Oracle client library required.
You are going to need the Oracle client drivers from Oracle also as I
remember (SQL *Net)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119907568.126869.35880@.g43g2000cwa.googlegro ups.com...
> If I want to use DTS export table to Oracle from SQL Server, what all
> drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
> Does any other Oracle client library required.
>
Showing posts with label export. Show all posts
Showing posts with label export. Show all posts
Sunday, February 26, 2012
Drivers for DTS to Oracle
If I want to use DTS export table to Oracle from SQL Server, what all
drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
Does any other Oracle client library required.You are going to need the Oracle client drivers from Oracle also as I
remember (SQL *Net)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119907568.126869.35880@.g43g2000cwa.googlegroups.com...
> If I want to use DTS export table to Oracle from SQL Server, what all
> drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
> Does any other Oracle client library required.
>
drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
Does any other Oracle client library required.You are going to need the Oracle client drivers from Oracle also as I
remember (SQL *Net)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119907568.126869.35880@.g43g2000cwa.googlegroups.com...
> If I want to use DTS export table to Oracle from SQL Server, what all
> drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
> Does any other Oracle client library required.
>
Drivers for DTS to Oracle
If I want to use DTS export table to Oracle from SQL Server, what all
drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
Does any other Oracle client library required.You are going to need the Oracle client drivers from Oracle also as I
remember (SQL *Net)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119907568.126869.35880@.g43g2000cwa.googlegroups.com...
> If I want to use DTS export table to Oracle from SQL Server, what all
> drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
> Does any other Oracle client library required.
>
drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
Does any other Oracle client library required.You are going to need the Oracle client drivers from Oracle also as I
remember (SQL *Net)
Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know
"Data Cruncher" <dcruncher4@.netscape.net> wrote in message
news:1119907568.126869.35880@.g43g2000cwa.googlegroups.com...
> If I want to use DTS export table to Oracle from SQL Server, what all
> drivers I need. One is I believe MS ODBC Driver to connect to Oracle.
> Does any other Oracle client library required.
>
Friday, February 17, 2012
drilldown in excel and PDF
I have a report that has the drilldown function in it with the +/-
sign. When I export the report to excel or PDF, the drilldown
functionality is lost and I am not able to view the info at the lower
level's.
If I expand all the drilldown's and export it, then all the info shows
but the +/- still doesn't show up in excel or PDF.
I am currently running RS SP2.
does anyone know the reason why it's doing this?That is the way those types are rendered. They do not have the drill down
capability.
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||Something has to be wrong...
For starters:
PDF files will ONLY show the report exactly how it looks - i.e. if some
components are collapsed, and others expanded, then that is EXACTLY what you
get when you export to PDF.
EXCEL on the other hand WILL show drill-downs and carry that
functionality into the excel workbook itself. I.e. You can after exporting
into Excel drill-down into your data or collapsed as if you were on the
report server web page viewing this report.
One of the issues with Excel drill downs is when people use a SubReport.
Subreports do not render into Excel at all. (Pisses me off of course) :) Are
you using a subreport?
=-Chris
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||no, all the data is part of the same report.
basically, the root level shows a customer's name and their financial
info and when the user clicks on the drilldown +/- it's supposed to
show the customer's address info. All of the info come from the same
dataset or query.
I wonder if it has anything to do with SP2.
Chris Conner wrote:
> Something has to be wrong...
> For starters:
> PDF files will ONLY show the report exactly how it looks - i.e. if some
> components are collapsed, and others expanded, then that is EXACTLY what you
> get when you export to PDF.
> EXCEL on the other hand WILL show drill-downs and carry that
> functionality into the excel workbook itself. I.e. You can after exporting
> into Excel drill-down into your data or collapsed as if you were on the
> report server web page viewing this report.
> One of the issues with Excel drill downs is when people use a SubReport.
> Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> you using a subreport?
> =-Chris
> "bevarg" <benovarghese@.gmail.com> wrote in message
> news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> >I have a report that has the drilldown function in it with the +/-
> > sign. When I export the report to excel or PDF, the drilldown
> > functionality is lost and I am not able to view the info at the lower
> > level's.
> > If I expand all the drilldown's and export it, then all the info shows
> > but the +/- still doesn't show up in excel or PDF.
> > I am currently running RS SP2.
> >
> > does anyone know the reason why it's doing this?
> >|||Has chris said it works fine with excel. Sometimes we miss out simple things,
Just in case , in excel the + sign ie grouping happens and it is extreme left
side of the sheet or the screen itself. hope you noticed this. If it is still
not there.
Amarnath
"bevarg" wrote:
> no, all the data is part of the same report.
> basically, the root level shows a customer's name and their financial
> info and when the user clicks on the drilldown +/- it's supposed to
> show the customer's address info. All of the info come from the same
> dataset or query.
> I wonder if it has anything to do with SP2.
>
> Chris Conner wrote:
> > Something has to be wrong...
> >
> > For starters:
> > PDF files will ONLY show the report exactly how it looks - i.e. if some
> > components are collapsed, and others expanded, then that is EXACTLY what you
> > get when you export to PDF.
> >
> > EXCEL on the other hand WILL show drill-downs and carry that
> > functionality into the excel workbook itself. I.e. You can after exporting
> > into Excel drill-down into your data or collapsed as if you were on the
> > report server web page viewing this report.
> >
> > One of the issues with Excel drill downs is when people use a SubReport.
> > Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> > you using a subreport?
> >
> > =-Chris
> >
> > "bevarg" <benovarghese@.gmail.com> wrote in message
> > news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> > >I have a report that has the drilldown function in it with the +/-
> > > sign. When I export the report to excel or PDF, the drilldown
> > > functionality is lost and I am not able to view the info at the lower
> > > level's.
> > > If I expand all the drilldown's and export it, then all the info shows
> > > but the +/- still doesn't show up in excel or PDF.
> > > I am currently running RS SP2.
> > >
> > > does anyone know the reason why it's doing this?
> > >
>
sign. When I export the report to excel or PDF, the drilldown
functionality is lost and I am not able to view the info at the lower
level's.
If I expand all the drilldown's and export it, then all the info shows
but the +/- still doesn't show up in excel or PDF.
I am currently running RS SP2.
does anyone know the reason why it's doing this?That is the way those types are rendered. They do not have the drill down
capability.
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||Something has to be wrong...
For starters:
PDF files will ONLY show the report exactly how it looks - i.e. if some
components are collapsed, and others expanded, then that is EXACTLY what you
get when you export to PDF.
EXCEL on the other hand WILL show drill-downs and carry that
functionality into the excel workbook itself. I.e. You can after exporting
into Excel drill-down into your data or collapsed as if you were on the
report server web page viewing this report.
One of the issues with Excel drill downs is when people use a SubReport.
Subreports do not render into Excel at all. (Pisses me off of course) :) Are
you using a subreport?
=-Chris
"bevarg" <benovarghese@.gmail.com> wrote in message
news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
>I have a report that has the drilldown function in it with the +/-
> sign. When I export the report to excel or PDF, the drilldown
> functionality is lost and I am not able to view the info at the lower
> level's.
> If I expand all the drilldown's and export it, then all the info shows
> but the +/- still doesn't show up in excel or PDF.
> I am currently running RS SP2.
> does anyone know the reason why it's doing this?
>|||no, all the data is part of the same report.
basically, the root level shows a customer's name and their financial
info and when the user clicks on the drilldown +/- it's supposed to
show the customer's address info. All of the info come from the same
dataset or query.
I wonder if it has anything to do with SP2.
Chris Conner wrote:
> Something has to be wrong...
> For starters:
> PDF files will ONLY show the report exactly how it looks - i.e. if some
> components are collapsed, and others expanded, then that is EXACTLY what you
> get when you export to PDF.
> EXCEL on the other hand WILL show drill-downs and carry that
> functionality into the excel workbook itself. I.e. You can after exporting
> into Excel drill-down into your data or collapsed as if you were on the
> report server web page viewing this report.
> One of the issues with Excel drill downs is when people use a SubReport.
> Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> you using a subreport?
> =-Chris
> "bevarg" <benovarghese@.gmail.com> wrote in message
> news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> >I have a report that has the drilldown function in it with the +/-
> > sign. When I export the report to excel or PDF, the drilldown
> > functionality is lost and I am not able to view the info at the lower
> > level's.
> > If I expand all the drilldown's and export it, then all the info shows
> > but the +/- still doesn't show up in excel or PDF.
> > I am currently running RS SP2.
> >
> > does anyone know the reason why it's doing this?
> >|||Has chris said it works fine with excel. Sometimes we miss out simple things,
Just in case , in excel the + sign ie grouping happens and it is extreme left
side of the sheet or the screen itself. hope you noticed this. If it is still
not there.
Amarnath
"bevarg" wrote:
> no, all the data is part of the same report.
> basically, the root level shows a customer's name and their financial
> info and when the user clicks on the drilldown +/- it's supposed to
> show the customer's address info. All of the info come from the same
> dataset or query.
> I wonder if it has anything to do with SP2.
>
> Chris Conner wrote:
> > Something has to be wrong...
> >
> > For starters:
> > PDF files will ONLY show the report exactly how it looks - i.e. if some
> > components are collapsed, and others expanded, then that is EXACTLY what you
> > get when you export to PDF.
> >
> > EXCEL on the other hand WILL show drill-downs and carry that
> > functionality into the excel workbook itself. I.e. You can after exporting
> > into Excel drill-down into your data or collapsed as if you were on the
> > report server web page viewing this report.
> >
> > One of the issues with Excel drill downs is when people use a SubReport.
> > Subreports do not render into Excel at all. (Pisses me off of course) :) Are
> > you using a subreport?
> >
> > =-Chris
> >
> > "bevarg" <benovarghese@.gmail.com> wrote in message
> > news:1162502355.922494.29120@.f16g2000cwb.googlegroups.com...
> > >I have a report that has the drilldown function in it with the +/-
> > > sign. When I export the report to excel or PDF, the drilldown
> > > functionality is lost and I am not able to view the info at the lower
> > > level's.
> > > If I expand all the drilldown's and export it, then all the info shows
> > > but the +/- still doesn't show up in excel or PDF.
> > > I am currently running RS SP2.
> > >
> > > does anyone know the reason why it's doing this?
> > >
>
Subscribe to:
Posts (Atom)