SurendraThotaMSBIProfessional

SQL Server integration services   2008 provides 3 new connectivity options . The three new connectors (for Oracle, Teradata and SAP BW) will be available as a downloadable feature pack for Enterprise Edition. In this Paper I will Explain you how to use Teradata connectivity in SSIS . I am going to explain how to connect ADO NET Source to connect teradata database. How to use parameterized teradata queries in SSIS Integration services – Teradata   connectivity For any Dot net application to connect Terdata database we need to have Teradata .Net Provider . This is required for SSIS also . The Offical downloads for   Teradata .Net data Provider are available at http://downloads.teradata.com/download/connectivity/dot-net-data-provider The first step we need to do to connect teradata from SSIS is install   teradata .Net data provider   in the system . Step 1 : Create connection manager     First create a connection manag...

In SSRS 2008R2 you can have control on Rendering Reports . Reporting Services built-in rendering extension names include: " WORD ", " EXCEL ", " PDF ", " MHTML ", " IMAGE " (includes TIFF, Print). Note that interactive viewing in preview or report manager uses the " RPL " renderer. Some of the Few Actions which we did in our project are like   : 1.Disable the Go to Action Report ( ie to go to SubReport) from   hyperlink in a rendered report in Excel . Solution : You'll need to go to the Action section on the cell which has the hyperlink. You probably have set the "Go to Report" action. Instead of just specifying the report, you'll need to specify an expression for it instead, something like this: IIf(Globals!RenderFormat.Name = "EXCEL", Nothing, "YourReportPath") OR you could also use the .IsInteractive property, which will disable the links for PDF exports as well: IIf(Glo...