View Single Post
  #5 (permalink)  
Old August 22nd, 2006, 10:11 PM
kkrish kkrish is offline
Registered User
 
Join Date: Jun 2006
Location: , , .
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I am passing a value in the format 'MM/DD/YYYY' from a data file, to @createdate using dynamic properties task.

If I use
CreationDate = "'+convert(varchar(20),@createdate,101)+'"

I am getting the syntax error.

Please advise.

Thanks.

Reply With Quote