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.
43 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
Good information.
B.com Integrated Courses | 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
Hi Thanks for the nice information its very useful to read your blog. We provide best Block Chain Services
Hi Thanks for the nice information its very useful to read your blog. We provide best SYSTEM INTEGRATION SERVICES
Thank you for sharing this valuable information. But get out this busy life and find some peace with a beautiful trip. book Andaman Tourism
Thank you for sharing this valuable information. But get out this busy life and find some peace with a beautiful trip. book Best Travel Agency In India
Hi Thanks for the nice information its very useful to read your blog. We provide best Association Of Chartered Certified Accountants
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
Good...
internships in chennai
winter internship mechanical engineering
internship for aeronautical engineering students in india 2019
kaashiv
list of architectural firms in chennai for internship
paid internships in pune for computer science students
diploma final year project topics for information technology
internship
data science internship report
inplant training
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
very nice post.........
r programming training in chennai
internship in bangalore for ece students
inplant training for mechanical engineering students
summer internships in hyderabad for cse students 2019
final year project ideas for information technology
bba internship certificate
internship in bangalore for ece
internship for cse students in hyderabad
summer training for ece students after second year
robotics courses in chennai
Nice Infromation....
internship in chennai for ece students with stipend
internship for mechanical engineering students in chennai
inplant training in chennai
free internship in pune for computer engineering students
internship in chennai for mca
iot internships
internships for cse students in hyderabad
implant training in chennai
internship for aeronautical engineering students in bangalore
inplant training certificate
nice post.......
apache solr resume sample
apache spark sample resume
application developer resume samples
application support engineer resume sample
asp dotnet mvc developer resume
asp net core developer resume
asp net developer resume samples
assistant accountant cv sample
assistant accountant resume
assistant accountant resume sample
nice....
category/advocate-resume
category/agriculture-forestry-fishing
category/android-developer-resume
category/assistant-professor-resume
category/chartered-accountant-resume
category/database-resume
category/design-engineer-resume
category/developer-resume
category/engineer-resume
category/entrepreneur-and-financial-services-resume
good..nice..
assistant-director-resume-format
assistant-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
good ....nice...
resume/category/software-testing-resume
resume/category/sslc-resume
resume/category/storekeeper-resume
resume/category/stylist-resume
resume/category/teachers-resume
resume/category/technical-architect-resume
resume/category/web-developer-resume
cics-system-programmer-resume-example
resume/cisco-network-engineer-resume
resume/cisco-network-engineer-resume-sample
good.....nice..
category/maintenance-resume
category/manager-resume
category/mechanical-engineering-resume
category/network-engineer-resume
category/officer-resume
category/operations-resume
category/process-associate-resume
category/quality-control-resumes
category/software-engineer-resume
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
it is best blogs ....
civil-engineer-resume-format
client-service-executive-resume-sample
cognos-developer-resume-samples
college-lecturer-resume
college-lecturer-resume-sample
commercial-assistant-resume-sample
compliance-officer-resume-samples
computer-teacher-resume-format
computer-teacher-resume-sample
cordova-developer-resume-sample
film-director-resume
finance-and-accounting-manager-resume-samples
finance-director-resume-examples
fire-safety-officer-resume-sample
fleet-maintenance-manager-resume-samples
format-for-resume-writing
fresher-computer-engineers-resume-sample
fresher-hr-resume-sample
fresher-hr-resume-sample-2
fresher-lecturer-resume
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
good .........very useful
fresher-marketing-resume-sample
front-end-developer-resume-sample
full-stack-developer-resume-samples
fund-accountant-resume-samples
general-ledger-accountant-resume-sample
government-jobs-resume
hadoop-developer-sample-resume
hadoop-developer-sample-resume
hardware-and-networking-resume-samples
hardware-engineer-resume-sample
Such a very useful information!Thanks for sharing this useful information with us. Really great effort.
Artificial Intelligence Training institute in Bangalore
Artificial Intelligence Training institute in India
Artificial Intelligence Training course
Artificial Intelligence Training in Bangalore
Great Article
Artificial Intelligence Projects
Project Center in Chennai
JavaScript Training in Chennai
JavaScript Training in Chennai
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