June 21, 2011 at 12:54 pm
Insert into hs(Id, Date, time)
select utid,date,time
from time t
where transactiontime between ? and ?
I have created the varibles startdate and enddate as datetime
Sourcetype as directinput and resultset to none
When I execute the sql task I get the error as
"Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
June 21, 2011 at 1:01 pm
Sachin4all (6/21/2011)
Insert into hs(Id, Date, time)select utid,date,time
from time t
where transactiontime between ? and ?
I have created the varibles startdate and enddate as datetime
Sourcetype as directinput and resultset to none
When I execute the sql task I get the error as
"Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
To narrow it down, try hard-coding the entire SQL insert and running again. If it succeeds, you'll know to focus attention on the parameters.
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 21, 2011 at 1:54 pm
How many records are you typically going to be inserting? If its a lot I wouldn't do this in an EXEC SQL task but a Data-Flow task.
CEWII
June 21, 2011 at 2:48 pm
There are a lot but thats fine......
The thing is i am unable to map the parameters correctly
June 21, 2011 at 2:50 pm
@phil
If i remove the ? and hardcode the task...
Its working perfectly
June 21, 2011 at 6:01 pm
Try datatype DATE instead of DBTimestamp
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply