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.
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
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy