Click here to Skip to main content
15,860,972 members
Home / Discussions / Database
   

Database

 
GeneralRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 14:25
professionalMycroft Holmes29-Jul-14 14:25 
GeneralRe: How to Calculate Total Time Difference Pin
Andrius Leonavicius29-Jul-14 14:39
professionalAndrius Leonavicius29-Jul-14 14:39 
AnswerRe: How to Calculate Total Time Difference Pin
Mycroft Holmes29-Jul-14 14:29
professionalMycroft Holmes29-Jul-14 14:29 
AnswerRe: How to Calculate Total Time Difference Pin
Swinkaran4-Aug-14 16:28
professionalSwinkaran4-Aug-14 16:28 
QuestionSQL SERVER DBA--- HELP ME WITH THIS.... Pin
Member 1097517927-Jul-14 20:57
Member 1097517927-Jul-14 20:57 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Tim Carmichael28-Jul-14 2:58
Tim Carmichael28-Jul-14 2:58 
AnswerRe: SQL SERVER DBA--- HELP ME WITH THIS.... Pin
Mycroft Holmes29-Jul-14 14:33
professionalMycroft Holmes29-Jul-14 14:33 
QuestionProblem with SSIS 2012 Pin
amioni24-Jul-14 0:41
amioni24-Jul-14 0:41 
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.

SuggestionRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 1:57
mveRichard Deeming24-Jul-14 1:57 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 2:04
amioni24-Jul-14 2:04 
QuestionRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 2:13
mveRichard Deeming24-Jul-14 2:13 
AnswerRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 3:00
amioni24-Jul-14 3:00 
GeneralRe: Problem with SSIS 2012 Pin
Richard Deeming24-Jul-14 3:12
mveRichard Deeming24-Jul-14 3:12 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 3:25
amioni24-Jul-14 3:25 
QuestionRe: Problem with SSIS 2012 Pin
GuyThiebaut24-Jul-14 2:44
professionalGuyThiebaut24-Jul-14 2:44 
AnswerRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 2:51
amioni24-Jul-14 2:51 
AnswerRe: Problem with SSIS 2012 Pin
GuyThiebaut24-Jul-14 3:26
professionalGuyThiebaut24-Jul-14 3:26 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 4:09
amioni24-Jul-14 4:09 
GeneralRe: Problem with SSIS 2012 Pin
GuyThiebaut24-Jul-14 4:43
professionalGuyThiebaut24-Jul-14 4:43 
GeneralRe: Problem with SSIS 2012 Pin
jschell24-Jul-14 11:44
jschell24-Jul-14 11:44 
GeneralRe: Problem with SSIS 2012 Pin
amioni24-Jul-14 21:54
amioni24-Jul-14 21:54 
AnswerRe: Problem with SSIS 2012 Pin
amioni1-Sep-14 23:52
amioni1-Sep-14 23:52 
Questionsql server Pin
saharmirzaei23-Jul-14 8:12
saharmirzaei23-Jul-14 8:12 
QuestionRe: sql server Pin
Richard Deeming23-Jul-14 8:17
mveRichard Deeming23-Jul-14 8:17 
AnswerRe: sql server Pin
saharmirzaei23-Jul-14 22:30
saharmirzaei23-Jul-14 22:30 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.