Skip to main content

Hello dear TX Community,

We want to load tables from our ERP System, and we are encountering the following error: HRESULT: 0xC0010006.

This error indicates that the name of the SSIS Package created is too long, and we need to shorten it. I've attempted to shorten the name by modifying the schema name we agreed upon, but this would only be a temporary solution as there are more tables with longer names. For your information, the package name typically consists of the following parameters: connector name - schema name - table name - SSIS-ID, for example, sql91_DBTest_zzdomAG_DBTest_dbo_SalesAppointment_3d5329a2-54ab-42a1-9126-4c21d569131ce.

Now, I have the following questions:

1. How can I manipulate/shorten the package name apart from changes I can make to the connector name and schema name (in TX)?
2. Is the SSIS-ID always generated with the same string sequence, and is there a specific use case behind it that requires the ID to be formatted this way?

kind regards Faras E.Nazeri

Hi @FEN 

Are you using business unit or ODX? if you are using business units can you please try using the “Don't prefix tables” option by right-clicking the relevant data source and selecting data source settings and then choosing “Don’t prefix tables”?

 


Hi @FEN 

Are you using business unit or ODX? if you are using business units can you please try using the “Don't prefix tables” option by right-clicking the relevant data source and selecting data source settings and then choosing “Don’t prefix tables”?

 

Hi Christian,

 

First and foremost, thank you for your answer. I'm using the business unit. I've already tried that, but the length of some names is still too large. Additionally, I attempted to modify the name in the Integration Service (Server type) see the first screenshot] so I can read the new SSIS Package with the customized option tsee the second screenshot]. In the end, that didn't work either.

Can I change the name of the table within the business unit? (I know I can rename the original table name, but it also doesn't change the name.) I would like to keep the schema name.

 

 

 

 

 


@FEN you mention that the package name was:

sql91_DBTest_zzdomAG_DBTest_dbo_SalesAppointment_3d5329a2-54ab-42a1-9126-4c21d569131ce

When you applied don’t prefix tables what is the new package name?

Can you please send a screenshot of the BU data source and the Business Unit table?

 


@FEN also can you please try to create a query table with a shorter table name and use this query table instead of extracting the source table directly?

 


Reply