SurendraThotaMSBIProfessional

Error msg: [Flat File Source [1]] Error: Data conversion failed. The data conversion for column "PoolOverage" returned status value 6 and status text "Conversion failed because the data value overflowed the specified type.". [Flat File Source [1]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.   The "output column "PoolOverage" (106)" failed because error code 0xC0209087 occurred, and the error row disposition on "output column "PoolOverage" (106)" specifies failure on error. An error occurred on the specified object of the specified component.   There may be error messages posted before this with more information about the failure. [Flat File Source [1]] Error: An error occurred while processing file "\\xxxxx\Cr-sql-cpp\M2M\Dev\MonthlyUsage\processing\SIMSummaries\SIMSummaries-2014-03-22027344805.csv" on data row 1. [SSIS.Pipeline] Error: SSIS Error Code DTS_E_PRIMEOUTPUTFAILED.   The PrimeO...

1.       Error msg: [OLE DB Destination [138]] Error: SSIS Error Code DTS_E_OLEDBERROR.   An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available.   Source: "Microsoft SQL Server Native Client 10.0"   Hresult: 0x80004005   Description: "Invalid character value for cast specification". [OLE DB Destination [138]] Error: There was an error with input column "finDate" (2050) on input "OLE DB Destination Input" (151). The column status returned was: "The value could not be converted because of a potential loss of data.". [OLE DB Destination [138]] Error: SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR.   The "input "OLE DB Destination Input" (151)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (151)" specifies failure on error. An error occurred on the specified object of the specified compone...

when we are loading data from Sharepoint list  we will get some extra characters with the actual colum value . For example : if the column (Level 1) value is Collaboartion then when we are using SSIS that value will come like 16;#Collaboration . But we need to store only actual data in that case we need to correct that column data . To solve this issue we need to keep a derived column after sharepointlist source  and give the Expression SUBSTRING([Level 1],FINDSTRING([Level 1],"#",1) + 1,255 - FINDSTRING([Level 1],"#",1)) i will explain you how it will work for Example if we take column value  16;#Collaboration FINDSTRING([Level 1],"#",1)  this function retuns value where search string occurs for the first time in the above case it 4  so the final substring expression looks like SUBSTRING('16;#Collaboration',4 + 1,255 - 4) SUBSTRING('16;#Collaboration',5,251) This returns substring from 5th position to 251 position  w...

1.First step we need to install Sharepoint List Source and destination connections adatoptor . In one of our new application we need to pull the data from sharepoint list using SSIS package . for this we need to install sharepoint list source and Destination connections adaptors in sql server . those are available in codeplex site http://sqlsrvintegrationsrv.codeplex.com/releases/view/17652 2. Once the sharepoint list source and Destination connections adaptors are installed we need to select them from the choose Toolbox Items . For the this step   In BIDS select Tools Menu / choose Tool box items   then a window opens as shown below . Select SSIS Data Flow Items Tab   and in that select sharepoint List Destination and SharepointList Source . Now you are able to see the adaptors in BIDS toolbox as showm below. 3. To load the data from sharepointlist we need to select Dataflowtask and in that DFT we need to select sharepoint list source to...

i will let you how to use Regular Expression in Tsql using one example / we need to filter the data of varchar column ,  value should be like DSx_HD_WSxx  example  DS1_HD_WS01_blablabla . for this we can achieve by using ' DS__HD_WS__%'  but the problem is, we can also get DS10 or DS1000 . In this case what pattern we need to use to accept any number after DS  then remaining as per previous patern. we can achieve solution with the fallowing expression 'DS%[_]HD_WS%[_]%' For single character we need to use  underscore _  and for many chacters we need to use %

we have SSRS report where we have used many text boxes to display the results . when we preview the report the page is breaking between 2 textboxes  and when we rendered this report to word we are getting more space between those 2 text boxes  .  and another issue is when we given print that word doc the actual text is printing from middle of the paper  leaving space before that text First of all why we get this issue . After the report is opened in Word, Word repaginates the entire report again based on the page size. Repagination may cause page breaks to be inserted in locations where you did not intend to add them and, in some instances, may cause the exported report to have two successive page breaks in a row or add blank pages. The extra space may be cause by the repagination. In your scenario, you can drag your textbox to the rectangle control, and then reset the position of it. Regerence: Pagination After Export to Word Pagination in Reporting Se...

Hi All i will explain you the mdx error i have encountered and its solution . we have written and mdx query to give result of successrate based on certain dimensions select non empty ([D Date].[Hierarchy]. members ) on 1, Sum ( ( [D Application].[Application].&[S6a/S6d] ,[D Command].[Command].&[ULR] ,{ Except ([D Origin Realm].[Origin Realm],[D Origin Realm].[Origin Realm].&[epc.mnc001.mcc206.3gppnetwork.org])} ,[D Destination Realm].[Destination Realm].&[epc.mnc001.mcc206.3gppnetwork.org] ) ,[Measures].[SuccessRate] ) on 0 from [DRV] The Above query will return an Error The Axis0 function expects a tuple set expression for the argument. A string or numeric expression was used. The solution for this error is  we need to create the Member and then call that member in the select statement . WITH MEMBER NewMember AS SUM ( ( [D Application].[Application].&[S6a/S6d] ,[D Command].[Command].&[ULR] ,{ Except ([D Origin Realm].[Orig...

in one of my reauirement we need to create a measure  with fallowing condition Application = S6A/S6D Command = ULR Origin Realm <> epc.mnc001.mcc206.3gppnetwork.org * Destination Realm = epc.mnc001.mcc206.3gppnetwork.org Then we created calculated measure WITH MEMBER NewMember AS AGGREGATE ( (   [ D Application ].[ Application ].&[ S6a / S6d ]   ,[ D Command ].[ Command ].&[ ULR ]   ,{ Except ([ D Origin Realm ].[ Origin Realm ],[ D Origin Realm ].[ Origin Realm ].&[ epc . mnc001 . mcc206 . 3gppnetwork . org ])}   ,[ D Destination Realm ].[ Destination Realm ].&[ epc . mnc001 . mcc206 . 3gppnetwork . org ] ) ,[ Measures ].[ SuccessRate ] ) SELECT [ Measures ].[ NewMember ] ON 0 , non empty ([ D Date ].[ Hierarchy ]. members ) on 1 from [ DRV ] then we got the error aggregate functions cannot be used on calculated measures in the measures dimension The reason for this error is SuccessRate is Calculated measure and we...