locked
Error while running SSIS package from sql server agent. RRS feed

  • Question

  • User1627454785 posted

    Hi,

      I have a SSIS package in VSS.Iwas able to create job for this ssis package and run successfully in my local.Whereas when i place the same on server it is throwing error.IN one of my dataflow task I used derived columns i.e to convert dt_date to databsetimestamp.When I exceute the package it is running with out errors.But when I create a job and try to run the job it is giving the error "cannot ocnvert dt_date to databasetimestamp".

      Can anyone please help me on this.

      Any help is much appreciated.

     

    Thanks

    Sri

    Tuesday, August 9, 2011 11:58 PM

Answers

  • User1627454785 posted

    Thanks for the inputs TImoYang.

    Till now iam trying to deploy the solution when package configuration is enablled.I disabled it and tried deploying and it worked like a magic !!.

    Cheers

    Sri

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 14, 2011 1:23 AM

All replies

  • User-1488931086 posted

    Hey man!

    You should notice the conversion: http://msdn.microsoft.com/en-us/library/ms141036.aspx

    Wednesday, August 17, 2011 4:00 AM
  • User1627454785 posted

    Thanks for the inputs TImoYang.

    Till now iam trying to deploy the solution when package configuration is enablled.I disabled it and tried deploying and it worked like a magic !!.

    Cheers

    Sri

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Wednesday, September 14, 2011 1:23 AM