Forum Replies Created

Viewing 10 posts - 31 through 40 (of 40 total)

  • RE: Data Cleansing With SSIS

    the decode table is supposed to refer to a "parameterlist table" where you correlate certain values to keys or other values eg.

    ParameterName Code Key...

  • RE: SSIS Error when importing Excel 2007 (xlsx) spreadsheet with chart

    I second that as well... excel used to give me a hard time trying to import data, date figures seldom did get messed up too. txt and csv extensions are...

  • RE: Data File Space Cleansing

    The file has more than 200,000 records, deleting the blank spaces from every single line manually through notepad/wordpad.... would take hours. As for reading the values from the column &...

  • RE: Data File Space Cleansing

    The file has more than 200,000 records, deleting the blank spaces from every single line manually through notepad/wordpad.... would take hours. As for reading the values from the column &...

  • RE: Currency Formatting

    Dear Peter,

    I have already tried the regional settings option and it didn't help much in my case... In the Regional Options tab > Customize In the Numbers tab > Digit...

  • RE: Currency Formatting

    Dear Peter,

    The code definitely worked... even on dundas charts. However I was looking for something on a more global level, maybe reporting services due to the fact that i need...

  • RE: Date Conversion failure

    Point is, that these fields need to be evaluated through certain conditions before being mapped to target destination. And it is at this stage when converted to date using the...

  • RE: OLEDB Command fails pre-execute phase

    Solved: The components that relate to the temporary tables should have the Persist Security Info property in the OLEDB Connection manager set to False, while the rest of the transformations...

  • RE: OLEDB Command fails pre-execute phase

    The delay validation property is already set to true and the temporary table is not related to the procedure in any way! I tried to disable the DFT that is...

  • RE: Similarity Metrics

    Compared Fuzzy lookup similarity results on 20,000 rows of names to the similarity score returned by the following metrics: Levenstein, ChapmanLengthDeviation, Jaro, NeedleManWunch, SmithWaterman and QGramsDistance. Levenstein metric...

Viewing 10 posts - 31 through 40 (of 40 total)