July 25, 2011 at 12:53 am
getting the below erorr when executing one ssis package.
The external column "column_a" (1414) needs to be removed from the external columns.
Note:
The same ssis package is running succesfully in another server.
July 25, 2011 at 2:24 pm
This could be applicable.
http://stackoverflow.com/questions/687727/ssis-external-metadata-column-needs-to-be-removed
July 25, 2011 at 2:39 pm
It seems that there are differences in table and stored proc differences. Check out that article provided. Also, you may want to compare databases to ensure the two are alike (between server that works and server that doesn't).
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy