To homepage To homepage
Solved

SSIS Transfer failure Package because of the packagename length

  • 4 April 2024
  • 4 replies
  • 38 views
F
Rank

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

icon

Best answer by Christian Hauggaard 17 April 2024, 13:34

View original

4 replies

Christian Hauggaard
Rank
Userlevel 6
Badge +5

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”?

 

F
Rank

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 [see 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.

 

 

 

 

 

Christian Hauggaard
Rank
Userlevel 6
Badge +5

@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?

 

Christian Hauggaard
Rank
Userlevel 6
Badge +5

@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


Terms and ConditionsCookie settings