Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. joe69008

    Cognos 8.4. report schedule issue

    Hi everybody, I try to schedule a report in IBM connection. when the report should be created, i have this error : " CNC-SDS-0413 , user authentification failed". I've already try to renew the credential but nothing changed. Someone have an idea? Thanks in advance for your help.
  2. joe69008

    variables in Script task VS Script Component

    Hi, How do I reference and modify package scope variables in a script component (within a data flow task)? I tried copying the syntax I used in a Script task, but got a "Dts" not declared: Dts.Variables("User::MESSAGE_ERREUR").Value = ... Above works in Control flow Script task, but not...
  3. joe69008

    SSIS Generate an error in a data flow

    Public Overrides Sub Entrée0_ProcessInputRow(ByVal Row As Entrée0Buffer) ' Me.ComponentMetaData.FireError(-1, "error", "error null", "", 1, True) ' End Sub End Class thanks
  4. joe69008

    SSIS Generate an error in a data flow

    hi again!!! A last question please, can we generate a raiserror in a component script task or can we use the function exeption. a thing like that : "Public Class ScriptMain Inherits UserComponent Public Overrides Sub Entrée0_ProcessInputRow(ByVal Row As Entrée0Buffer) '...
  5. joe69008

    SSIS Generate an error in a data flow

    thank u very much for your help
  6. joe69008

    SSIS Generate an error in a data flow

    It's OK , thanks a lot for your help. A last question please, when the process don't run anymore, can we manage to show a message box for example or put the data flow in question in red , to show tu the user that the process stopped, because now when he stopped, there are no way to see if the...
  7. joe69008

    SSIS Generate an error in a data flow

    Thanks for your help. When you said "If you have NULLS, the conditional Success & Variable leads to the loading of the Refusal table which is your last step along that path" it will be the last step of my data flow but the others data flow in the control flow will goes on. No?
  8. joe69008

    SSIS Generate an error in a data flow

    I have a dataflow that read a table.(row : "id_agency","id_society","name_society","name_agency", "turnover") There is a conditional split where if i have a "id_agency" or "id_society" at blank , i load this wrong data (and so all the line data) in a table called Refusal. But after load all...
  9. joe69008

    problem of comma

    that exactly what i want, thanks you very much man.
  10. joe69008

    problem of comma

    Hi everybody, Small question please, I have one fields unit price which is formated in 5 decimals in the ERP on which i worked : XXX, XXXXX All the prices thus appear in this way: 12,90000 or 0,01230 or 1123,382000 Thus in crystal, I selectionne fields shaping - > number - > personalized and...
  11. joe69008

    crRTFText , how use this function???

    hi Rosemary, thanks for your invaluable advice, your are right and i am sorry for not have been precise since the beginning. I will be it for the next time;). so, the database is Oracle 9i.2, the crystal report version is 10 ans as for the ODBC drivers , I don't know! (how can we get this...
  12. joe69008

    Qlikview VS BO

    Thanks guys for your answers. ggerardo, Thanks for your help. Best regards.
  13. joe69008

    crRTFText , how use this function???

    hi everybody, Lbass, i have just tried your formula and Crystal give me the error : "error while compilation, 42000[data direct][ODBC Oracle driver] sql_varchar is not a valid ODBC SQL type for convert" Someone Know where the error come from? Thanks. Best regard
  14. joe69008

    crRTFText , how use this function???

    Excuse for not understand what you said before. So if that has nothing to do with modifying the database, when you said using a SQL expression, that meant with crystal report? That's right? and excuse for my mistake expression but I don't speak very english. thanks again. Best regard
  15. joe69008

    crRTFText , how use this function???

    I can't modify the database so I can't convert clob to vachar. According to you, cstr(clob-field) will work? thanks for your answers.
  16. joe69008

    crRTFText , how use this function???

    thanks for your answer, When i said , it's not good, it was means CR tell me an error. Excuse me for precise this. if not, i do like you said but the problem is this field is in subreport and i want to bring it in main report. and when i do "select format field->paragraph->text interpretation...
  17. joe69008

    crRTFText , how use this function???

    ...someone can explain me how to use this function i try crRTFText(database field) but crystal give me a error. i have a clob text like that {\rtf**.... and i want in a formula convert this text in rtf format to have a good text. i try "crRTFText({ACLOB.CLOB_0})" but it's no good. i also try...
  18. joe69008

    Qlikview VS BO

    Hi everybody, I am doing an study about the product to adopt to do report n my company. The choice is between BO and Qlikview. First of all, the main difference between both is the price. Qlikview is much less expansive than BO. But if it's less expansive, Qlikview must be less performant or...
  19. joe69008

    Qlikview, why is a revolution?

    thanks for your answer.
  20. joe69008

    Difference between ODS and DSA?

    So if we start a DWH project with 1/Immon's philosophy, so we use an ODS and the DWH is in 3NF and at least, we create datamarts and we can attack 2/ Kimball 's philosophy, so we use an DSA (like a temporary space) to create the datawarehouse(collection of datamart) thanks o lot for your...

Part and Inventory Search

Back
Top