09 diciembre 2007

CTE Expressions en SSIS

Hace algunas semanas a mi compañera Elizabeth Córdova le sucedió algo bastante extraño al intentar usar “expresiones CTE” en uno de sus paquetes, pueden ver el siguiente link para ver más de CTE http://msdn2.microsoft.com/en-us/library/ms190766.aspx.

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:

Priya Kannan dijo...

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

muthu dijo...

Nice blog...
Summer Course Training in Chennai | Summer Course Training in Madipakkam

Deepika dijo...

This is really great informative blog. Keep sharing.

Cloud services | Austere Technologies

Deepika dijo...

Nice blog with excellent information. Thank you, keep sharing.

Best Software company in USA | Austere Technologies

Deepika dijo...

Great article, really very helpful content you made. Thank you, keep sharing.

Application Quality Management Services | Austere Technologies

Deepika dijo...

wow...nice blog, very helpful information. Thanks for sharing.

Digital Transformation Services | Austere Technology Solutions

Deepika dijo...

Very good informative article. Thanks for sharing such nice article, keep on updating such good articles.

Internet Of Things Services | IOT | Austere Technology Solutions

Unknown dijo...

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

Unknown dijo...

Needed to compose one little word yet thanks for the suggestions that you are contributed here...
Best Online Software Training Institute | Artificial Intelligence Training

Austere dijo...

Great article, really very helpful content you made. Thank you, keep sharing.

Best Degree Colleges Hyderabad | Avinash College of Commerce

Austere dijo...

VERY INFORMATIVE BLOG. KEEP SHARING SUCH GOOD ARTICLES.

Best Commerce College in Hyderabad | Avinash College of Commerce

Deepika dijo...

VERY INFORMATIVE BLOG. THANK YOU.

Best junior college in Hyderabad | Avinash College of commerce

Deepika dijo...

Good information.

B.com Integrated Courses | Avinash College of commerce

Deepika dijo...

Really great blog, it's very helpful and has great knowledgeable information.

Best Blockchain services | Massil Technologies

Deepika dijo...

Really great information, keep sharing.

Best degree college in hyderabad

sandy dijo...

Hi Thanks for the nice information its very useful to read your blog. We provide best Block Chain Services

sandy dijo...

Hi Thanks for the nice information its very useful to read your blog. We provide best SYSTEM INTEGRATION SERVICES

sandy dijo...

Thank you for sharing this valuable information. But get out this busy life and find some peace with a beautiful trip. book Andaman Tourism

sandy dijo...

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

sandy dijo...

Hi Thanks for the nice information its very useful to read your blog. We provide best Association Of Chartered Certified Accountants

Deepika dijo...

Very interesting blog with excellent information.

ca coaching in hyderabad | Avinash college of commerce

Deepika dijo...

Great informative blog, keep for sharing.

Best Blockchain services | Massil Technologies

Deepika dijo...

Excellent informative blog, keep for sharing.

Best System Integration services | Massil Technologies

Deepika dijo...

Wow...Excellent informative blog. Thank you.

Best CA Training in hyderabad | ISFS

priya rajesh dijo...

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

nash b dijo...

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

shri dijo...

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

sugan dijo...

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

Muthu dijo...

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

sugan dijo...

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

shalini dijo...

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

Praisy Margret dijo...

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

reena dijo...

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

shalini dijo...

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

Praisy Margret dijo...


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

sibiselvan dijo...

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

reena dijo...



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


Praisy Margret dijo...

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

shalini dijo...

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

Arvind Kumar dijo...

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

IT dijo...

Great Article
Artificial Intelligence Projects

Project Center in Chennai



JavaScript Training in Chennai

JavaScript Training in Chennai

Mrbk30 dijo...

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

iteducationcentre dijo...

Nice article...
Thanks for sharing...
artificial intelligence training in Pune