We are connecting to a hadoop cluster

Just a small query. Can we start this series from '000' instead of 001?

Thanks alot. It helped me resolve the issue.

I cannot create fnTally function since it's a PLM system and object creation is not allowed.

there are 6500 rows in total so it will not reach till there

• This reply was modified 1 year, 11 months ago by  kirti.

Yes, the package fails on the first run, but gets executed in second or third turn. We have both 64 bit and 32 bit ODBC drivers installed and all 24...

Hi,

Thanks for the suggestion. I created the extended event successfully but while accessing it , it is throwing me the error: "The storage failed to initialize using the provided parameters....

thanks for the suggestions, I will try these and update the results.

Can we do updates in batches? If I have total record count of 10 million than what should be...

• This reply was modified 3 years, 6 months ago by  kirti.

It has a clustered index but clustered index column is not included in where clause nor in the list of columns getting updated.

Does dropping a clustered index before update helps...

destination is fast load

destination table has indexes which we are dropping and recreating.

datatypes are mostly varchar

Its the default setting for OLEDB destination. Any recommendation on commit size?

Auto adjust buffer size is from 2016, mine is SSIS 2012.