Click here to Skip to main content
15,041,525 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
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
Posted
Comments
bbirajdar 2-Aug-13 5:45am
   
check the connection string. The connection string and the sql server you are using is different
[no name] 2-Aug-13 8:48am
   
please post the piece of code..else it is difficult to imagine the things.

1 solution

SQL
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.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900