none
Import Data from Excel 2007 RRS feed

  • 問題

  • I import data from Excel 2007 .xlsx files. At perfroming operation, there are 11 tasks. From 1st task to 8th task, they are successful. At the 9th task, it is "excecuting". Its status is "In progress". then "Import and Export Data" System continue to stop at 9th task.  What's wrong? How should I find problem and solve?
    2009年8月5日 上午 06:18

解答

  • 1. Use VS open ssis package , right click on blank area, pick logging
    2. If there is some exception. you can try to add a sendmail task on "Event Handlers"
     Add a MessageSource expression as follow:

    "封裝名稱: " +  @[System::PackageName] + "\n" +

    "起始時間: " + RTRIM((DT_WSTR,30)@[System::StartTime]) + "\n" +

    "執行帳號: " +  @[System::UserName] + "\n" +

    "執行機器: " +@[System::MachineName] + "\n" +

    "錯誤碼: " + RTRIM((DT_WSTR,30)@[System::ErrorCode]) + "\n" +

    "錯誤訊息: " + @[System::ErrorDescription]+"\n"

    Then when package error occours you can receive a email with error message.
     
    Regards,


    Wilson
    • 已標示為解答 skychang 2009年8月13日 上午 08:35
    2009年8月6日 上午 09:04

所有回覆

  • Enable package logging so you can get details in the log.
    2009年8月5日 下午 01:29
  • How do I be enable package logging?
    2009年8月6日 上午 02:01
  • 1. Use VS open ssis package , right click on blank area, pick logging
    2. If there is some exception. you can try to add a sendmail task on "Event Handlers"
     Add a MessageSource expression as follow:

    "封裝名稱: " +  @[System::PackageName] + "\n" +

    "起始時間: " + RTRIM((DT_WSTR,30)@[System::StartTime]) + "\n" +

    "執行帳號: " +  @[System::UserName] + "\n" +

    "執行機器: " +@[System::MachineName] + "\n" +

    "錯誤碼: " + RTRIM((DT_WSTR,30)@[System::ErrorCode]) + "\n" +

    "錯誤訊息: " + @[System::ErrorDescription]+"\n"

    Then when package error occours you can receive a email with error message.
     
    Regards,


    Wilson
    • 已標示為解答 skychang 2009年8月13日 上午 08:35
    2009年8月6日 上午 09:04