Post reply

SSIS package fails when run as a job

  • June 26, 2007 at 12:23 pm

    #119656

    Hello,

    I am new to this forum and am a novice so am not sure if my questions belongs here or in the SSIS section but here goes....

    I have a package that is importing a text file and it runs fine in MS visual studio. When I try and run from the agent as a job, I am getting the following error:

    Event Name: OnError

    Message: Data conversion failed. The data conversion for column "XXXX" returned status value 4 and status text "Text was truncated or one or more characters had no match in the target code page.".

    I can run this fine under the sql agent account and the data is not exceeding the table limitation of length. As I said, the same data will process fine when run from studio. Not sure what else to try at this point...any help would be greatly appreciated.

  • June 27, 2007 at 5:03 pm

    #715664

    The first thing I have found with SSIS packages is that the security permissions between the BI studio and SQL are different so you need to make sure that the user that "own" the job in SQL has permissions to access the file. I have also found that using mapped drive letters through SQL doesnt go down so well and that UNC paths seem to resolve or manner of weird issues that come up only while running in SQL.

    Regarding your actual error message you are receiving - I have had this occur when the data column length in the destination is different or has been changed. Did you see this error message come up at all during your development? I have seen it happen where I have changed it & it runs OK in BI but still wont work in SQL. Make sure you redeploy the package with the correctly running package once again. (for some reason I had to do it several times??)

    Hope that helps?

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

  • June 28, 2007 at 7:44 am

    #715852

    Catherine,

    Thanks so much....redeployment worked. I know I redeployed after adjusting the length in the text connection and tables. In any case, it now works.

    Thanks so much, Clayton

  • June 28, 2007 at 7:54 am

    #715857

    No worries! Glad I could help!

    Kindest Regards,

    Catherine Eibner
    cybner.com.au

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply