Migrating table from sql server to pdw destination

  • During the migration of table from sql server to pdw destination. The table is excatly same in both sql server and pdw.

    The data load from oledb connection but when it got into pdw destination i got a error saying "Index was outside the bound of array." I dont have any index on my both table source and destination.

    Can you please help me out ? How can i get rid of those error ?

  • Although I don't know what the cause of the problem is, the error is not referring to a table index. An array has been created in the process and some code is referring to an array index position that does not exist.

    For example if you create a single dimension array with an lower bound of 1 and an upper bound of 10 but then you try and reference the index position of 11 you will get an error.

  • i think this is an application error, that has nothing to do with the data; might have something to do with permissions, though.

    how are you going into pwd destination? could you be using, say SSMS 2008R2 to connect to 2014, or vice versa?

    where i see this in an application is where the code refers to item[0] (the first item), but the process that loaded the item had an error, and the object with the expected items is not really an object or datatable or whatever.

    Lowell


    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply