That solved the problem.  I changed the script to just right Test to a variable and it ran without issue.  I have troubleshooted this is not some sort of configuration...

Thanks.

When I posted the question I had not read pages 10 - 14 that somewhat covered the reasons for not using it. Your answer got to the heart of...

So as a young developer myslef. What are the pitfalls of using the Select * ?

For those who are interested I wanted to post my work around for this issue. I finally came up with one. Although not the most Ideal situation it...

Yea did that too and still having the same issue. I is a nightmare no doubt.

Ok thanks. Oddly enough I think I got it working... Guess when you do it wrong enough you stumble upon the way it works LOL.

Actually I am using and SSIS package and still coming up with the same issue. I have checked my Metadata adn it is set up correctly. Also in the...

Would this be a Create Table statement in Execute File Task such as

CREATE TABLE [Losses$A10:AE10]?