Lo extraño del caso es que logró usar CTEs en sus paquetes en el entorno de desarrollo pasando la validación en tiempo de diseño que hace SSIS sin problema alguno tal como se muestra en la siguiente imagen:
Pero como se ve en la siguiente imagen, esto no funcionaba cuando movía el paquete al entorno de producción donde el OLEDB Source Component daba el siguiente mensaje de error cuando se quería hacer una vista preliminar de la data obtenida por el query:
Como ven, el mensaje de error menciona un error de sintaxis con el mensaje “Statement could not be prepared”…”Incorrect sintax near the keyword with” y finalmente la solución sugerida que dice ”if this is a CTE the previous statement must be terminated with a semicolon”, o mejor dicho cierre la expresión anterior con un punto y coma (;).
Finalmente el problema se solucionó poniendo el famoso punto y coma al inicio de la expresión CTE, algo como “; WITH Temp (……” (thanks to Jamie Thomson for his help and fast response!). Como empecé este post, lo extraño del caso es que en el entorno de desarrollo el paquete pasa la validación sin el punto y coma, pero en producción sí lo requiere. Obviamente lo único que podemos pensar es en alguna configuración diferente entre ambos entornos. Ambos tienen SQL 2005 SP2 y Windows Server 2003 SP1. Las ediciones de SQL usadas son Development y Enterprise respectivamente. Las ediciones de Windows 2003 también son Standard y Enterprise respectivamente.
Alguien sabe a ciencia cierta la explicación detallada para este funcionamiento irregular??
Alan.
24 comentarios:
This information really worth saying, i think you are master of the content and thank you so much sharing that valuable information and get new skills after refer that post.
Python Training in Chennai
Nice blog...
Summer Course Training in Chennai | Summer Course Training in Madipakkam
This is really great informative blog. Keep sharing.
Cloud services | Austere Technologies
Nice blog with excellent information. Thank you, keep sharing.
Best Software company in USA | Austere Technologies
Great article, really very helpful content you made. Thank you, keep sharing.
Application Quality Management Services | Austere Technologies
wow...nice blog, very helpful information. Thanks for sharing.
Digital Transformation Services | Austere Technology Solutions
Very good informative article. Thanks for sharing such nice article, keep on updating such good articles.
Internet Of Things Services | IOT | Austere Technology Solutions
MSBI is the newest powerful and useful tool used for business analysis. Thank you for sharing with us.
Python Training in Chennai
Python Training institute in Chennai
Needed to compose one little word yet thanks for the suggestions that you are contributed here...
Best Online Software Training Institute | Artificial Intelligence Training
Great article, really very helpful content you made. Thank you, keep sharing.
Best Degree Colleges Hyderabad | Avinash College of Commerce
VERY INFORMATIVE BLOG. KEEP SHARING SUCH GOOD ARTICLES.
Best Commerce College in Hyderabad | Avinash College of Commerce
VERY INFORMATIVE BLOG. THANK YOU.
Best junior college in Hyderabad | Avinash College of commerce
Really great blog, it's very helpful and has great knowledgeable information.
Best Blockchain services | Massil Technologies
Really great information, keep sharing.
Best degree college in hyderabad
Very interesting blog with excellent information.
ca coaching in hyderabad | Avinash college of commerce
Great informative blog, keep for sharing.
Best Blockchain services | Massil Technologies
Excellent informative blog, keep for sharing.
Best System Integration services | Massil Technologies
Wow...Excellent informative blog. Thank you.
Best CA Training in hyderabad | ISFS
Informative post, thanks for taking time to share this page.
Python Training in Chennai
Python course in Chennai
ccna Training in Chennai
AWS Training in Chennai
DevOps Training in Chennai
Angularjs Training in Chennai
RPA Training in Chennai
nice post...
internship report on python
free internship in chennai for ece students
free internship for bca
internship for computer science engineering students in india
internships in hyderabad for cse students 2018
electrical companies in hyderabad for internship
internships in chennai for cse students 2019
internships for ece students
inplant training in tcs chennai
internship at chennai
good... nice... very useful..
assistant-director-resume-format
director-resume-sample
assistant-professor-resume-sample
back-office-executive-resume-samples
bank-branch-manager-resume-samples
basketball-coach-resume-sample-coach-resumes
bca-fresher-resume-sample
best-general-manager-resume-example
bpo-resume-freshers-sample
bpo-resume-samples-for-freshers
useful information..nice..
devops-engineer-resume-samples
digital-marketing-resume-samples
digital-marketing-resume-samples
electronics-engineer-resume-sample
engineering-lab-technician-resume-samples
english-teacher-cv-sample
english-teacher-resume-example
english-teacher-resume-sample
excel-expert-resume-sample
executive-secretary-resume-samples
Very Informative blog thank you for sharing. Keep sharing.
Best software training institute in Chennai. Make your career development the best by learning software courses.
informatica classes in chennai
cloud computing courses in chennai
rpa training in chennai
Nice article...
Thanks for sharing...
artificial intelligence training in Pune
Publicar un comentario