Groups | Blog | Home
all groups > sql server dts > february 2007 >

sql server dts : Trying to set datetime output variable


Kayda
2/2/2007 9:09:12 PM
Hi:

I have an Execute SQL Task that takes input paramters and then is to
set one datetime variable as the output parameter. For the output
paramter there is no "datetime" variable type, only DBDATE and DBTIME.
When I execute the task I get an error saying that it is the wrong
datatype. My database value is set to datetime type, my variable is
datetime type, why can't my output parameter be datetime type?

Thanks,
Kayda
RLoski
2/3/2007 7:26:01 AM
Is this a question about DTS or SSIS?
--
Russel Loski, MCSD.Net


[quoted text, click to view]
AddThis Social Bookmark Button