I have been getting the following error when creating my DDT. It has not prevented me from completing my work but I would like to know what is happening? I am getting an IndexOutofRangeException Message stating that "There is no Row a Position 0.

How can I make it go away without blowing away my project work?

OK...that makes more sense.  Is sounds like you have an issue with one of your Data Deployment items.  Check to make sure that your query, server and password, database from which you are pulling, etc. is correct.  Also, if you are allowing the relationships to pull data from more than just itself (i.e. infinite, two deep, etc.) then that could be part of the problem as well...it would have something to do with the server from which is it pulling.  To prove that, you would want to reduce this to None or One to only pull in the data for that one table.  Try these items (since I cannot test that on my side with your data) and I am certain that one of these mentioned items will resolve your problem.

Just jumping in here... I'm having the same error when I choose to include deployment data which is just 2 simple tables. I checked authentication, etc.



Hmmmm... Why don't I just try blowing these away and re-creating their properties...



Yeah, that fixed it. Hope this helps. I'm guessing there were new options added in 1.6.6 that were not there when I set these up before.



- Randy

Thanks for sharing your solution!

I am not sure why re-creating them got it fixed as we did not change anything on that end...but I am glad it fixed your package.  We have some relatively complex data deployment packages within our medical app and everything seemed to be fine, but I appreciate your sharing this as it could be as simple as this if someone else is facing the same problem...though I would really like to know what caused that problem since this will be bugging me