Skip to main content
To homepage To homepage
Solved

SSIS Transfer failure Package because of the packagename length

F
Explorer
  • FEN
  • Explorer
  • 6 replies

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

Best answer by Christian Hauggaard

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

 

View original
Did this topic help you find an answer to your question?

4 replies

Christian Hauggaard
Community Manager
Forum|alt.badge.img+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
1 person likes this
F
Explorer
  • FEN
  • Author
  • Explorer
  • 6 replies
  • April 5, 2024
Christian Hauggaard wrote:

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
Community Manager
Forum|alt.badge.img+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
Community Manager
Forum|alt.badge.img+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


Most helpful members this week

Terms and ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings