ssis包中的错误 [英] error in ssis package

问题描述

大家好，

在ssis包中，我使用的是一个程序。当我执行反对ssms的程序时它的执行正常，但是当我执行包时我得到错误无效列< columnname>任何人都可以帮我解决这个问题。

谢谢&问候，

Prakash

Hi all,
In ssis package I am using one procedure. when I execute the procedure in against to ssms its executing fine, but when I execute package am getting error invalid column <columnname>could any one help me out for this problem.
Thanks & Regards,
Prakash

推荐答案

either your connection string is not correct.

your file that you are writting to does not have the columns mapped correctly.

in your sql select statement / stored procedure is missing a specified column or have a spelling error.

这篇关于ssis包中的错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！