|
Hello everyone,
I have a problem with my SSIS 2012, if I put in made a OLDBE Source with a complex query or composite sample
AS WITH TT
(
SELECT DISTINCT
e.UniqueID e. [Web Id] from Elements e) SELECT
DISTINCT *
'Class' + CAST (ROW_NUMBER () OVER (PARTITION BY [Web Id] ORDER BY [class] DESC) AS NVARCHAR) AS ClassNum
from TT
I have this error:
Exception From HRESULT: 0xC0202009
Error at Get Products SSIS Error Code DTS_E_OLEBDERROR. A OLE DB error has occured. Error code: 0x80004005
An OLE DB record is available. Source "Microsoft SQL Server Native Client 11.0" Hresult: 0x80004005 Description: "Syntax Error, permission violation, or nonspecific Reviews another error"
see Exhibit attached
Note that this same package works wonders on my colleague's machine with vs 2010
I do not understand the error!!
modified 24-Jul-14 8:04am.
|
|
|
|
|
This is an English-language forum. Please post your questions in English.
Il s'agit d'un forum de langue anglaise. S'il vous plaît envoyer vos questions en anglais.
https://translate.google.com/[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
|
Is your package running as a SQL Agent job? You might need to change the permissions on the TEMP directory:
http://support.microsoft.com/kb/933835[^]
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
i run it from VS2012 so i dont know if it s with sql agent or not (beginner )
and where i can find Temp directory
|
|
|
|
|
If you're running it from Visual Studio, then it's not using SQL Agent, so that's probably not the problem.
There seem to be lots of potential causes for that error message:
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
all of this properties are Ok and as i said this same package works wonders on my colleague's machine with vs 2010
i dont think it s a problem with connection string or else
|
|
|
|
|
amioni wrote: e.UniqueID e. [Web Id] from Elements
I am not seeing a comma between the two columns you reference, is that correct?
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
it s just an example of a query so dont worry it s with comma in my package, and it s not the problem
|
|
|
|
|
Always read the error message - Syntax Error, permission violation, or nonspecific Reviews another error
There is either:
An error in the sql - you can check this by running the sql in isolation.
A permission issue - harder to track, I would test this by creating a simple SSIS package and try to run it from your code.
Non specific error - eliminate the first two possibilities then look into this.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
NB : when i make this query in Stored procedure and i call it in the oledb source it work fine but not when i make it directly
|
|
|
|
|
I don't understand what that means - I will need more information to be able to help you.
“That which can be asserted without evidence, can be dismissed without evidence.”
― Christopher Hitchens
|
|
|
|
|
amioni wrote: NB : when i make this query in Stored procedure and i call it in the oledb source it work fine but not when i make it directly
A user (database) can have different permissions based on direct sql versus stored procs.
|
|
|
|
|
i am working with sa user (dev pc)
|
|
|
|
|
hi,
i answer myself because i found the solution:
with sql server native client 10 we can't add param with subquery
but this problem is resolved with SQL native client 11 (sql server 2012)
thank you
|
|
|
|
|
hi i found a Gregorian date conversion function in sql server but i dont know how i can use it!
could you help me?
|
|
|
|
|
Not without seeing it.
What are you trying to achieve? All date/datetime types in MSSQL already use the Gregorian calendar. Are you trying to convert to a Julian date? A different calendar system?
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
|
i wanna convert english calender to persian calender.i got this function but i cant use it.I am not a professional i MSSQL
|
|
|
|
|
Just put it back where you found it.
You'll never get very far if all you do is follow instructions.
|
|
|
|
|
thank you for your help 
|
|
|
|
|
Perhaps you actually think of a function for converting from/to Persian calendar?
|
|
|
|
|
yeah i think about it and i dont know how i can use this.
|
|
|
|
|
Seems to be a solved problem, have some google foo[^]
Never underestimate the power of human stupidity
RAH
|
|
|
|
|
I ran this in the Management Studio:
update [Master] set Data_Thru = '7/23/2014 9:49:00 AM'
where Data_Thru = '7/23/2014 8:00:00 AM'
So why did it actually set the smalldatetime to 7/23/2014 9:50:00 AM?
(And don't yell at me for the table name. It wasn't my idea.)
|
|
|
|
|
Are you absolutely sure that that's the precise query that you executed, and that the row you're looking at is the one it updated?
smalldatetime[^] will round to the nearest minute, but it will only round up if the seconds are greater than or equal to 29.999; anything else will round down.
SELECT
CAST('7/23/2014 9:49:29.998 AM' as smalldatetime),
CAST('7/23/2014 9:49:29.999 AM' as smalldatetime)
;
"These people looked deep within my soul and assigned me a number based on the order in which I joined."
- Homer
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
