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 manager with the provider .Net Provider

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

Required : In one of our requirement we need to show the message column as the combination of 4 columns in a Source , But SSRS we need to  show as Single column with  line sepeated of each Source column data . Example Meassage :  in Source Database we have 4 Text Columns with different language 1, NL_Text  2,Fr_Text 3,De_text  4,EN_Text but In report They  need to show as Single column  called Message  like 1 message    : NL_text : blabalabala .......                       Fr_Text : Blablabla.......                       DE_text :Blabla....                       EN_text :Blabla........... Solution :   Concatenate  4 columns in Source by appending some charecter to identify where to have a new line in between the message  . 'vbCrLf  NL Text : ' ||dyn_messagetext.nl_text || ' vbCrLf   Fr Text :' || dyn_messagetext.FR_text || '  as Meassage from Table In SSRS  Put an expression   =Replace(Fields!MESSAGETEXT.Value, "vbCrLf" ,vbCrLf)

Actual Error   :   In one of our new requirement we need to pull data from Excel file and load it in to Sql server table . The Package worked fine when it ran on my machine but when we   deployed the package into development   server and try to run it failed with fallowing error Description: SSIS Error Code DTS_E_OLEDB_NOPROVIDER_ERROR. The requested OLE DB provider Microsoft.ACE.OLEDB.12.0 is not registered. Error code: 0x00000000. An OLE DB record is available. Source: "Microsoft OLE DB Service Components" Hresult: 0x80040154 Description: "Class not registered". Root Cause   : On further analysis I discovered that one will get the above mentioned error when Microsoft Office 2007 is not installed on the machine where SQL Server 2008 Integration Services is installed. In order to import data from Microsoft Office Excel 2007 file formats such as .xls, .xlsx and .xlsb or from Microsoft Office Access 2007 file formats such as .mdb or .accdb files

Actual issue : when we rendered the SSRS report to WORD format and trying to print the report Then we will get an Error : The Margins of Section 1 are set outside the printable area of the page . Do you want to continue ? Root Cause   : Most printers cannot print all the way to the edge of the paper, because of physical limitations in the way that the printer handles paper. If you set your document margins or section margins closer to the edge of the paper than your printer is capable of printing, Microsoft Word returns an error message when you send your document to the printer. Reslution : The easiest way to avoid this issue is set the margin of your report a little big. I have tested it on my test environment. If I set the margin to 0.1in, then the issue appears, when I set the margin to 1in, the issue disappeared. Select Report in the Properties window, and set the margin to 1in.