Last post Sep 14, 2011 01:23 AM by ssowjanya
Aug 09, 2011 11:58 PM|ssowjanya|LINK
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.
Aug 17, 2011 04:00 AM|TimoYang|LINK
You should notice the conversion:
Sep 14, 2011 01:23 AM|ssowjanya|LINK
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 !!.